Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “pomfret” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

58 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
pomfret144699(None) 
pomfrets1543031pomfrets
coffret15310072coffret
comfrey1734682comfrey
befret11315963_befret
bomblet13412263bomblet
coffrets1645363coffrets
comet95946073com__et
comfier1439163comfier
comfiest1539133comfiest
comfit133112423comf_it
comfort143611693comfort
comfreys1843333comfreys
fret75845043___fret
gomerel1036393gomerel
hombre13309303hombre_
hombres14369873hombres
homered133212713homered
imaret81121233_imaret
offset1238373_offset
ombre94111803_ombre_
ombres103911143_ombres
omelet8317073_omelet
palfrey1533343palfrey
pocket144622623po_cket
poet65552903po___et
poitrel936193poitrel
pomace123111913pomace_
pomaces132712123pomaces
pomade113611333pomade_
pomaded13377863pomaded
pomades123711733pomades
pome85636693pom__e_
pomes94833933pom__es
pommee122813283pom_mee
pommel12277453pom_mel
pommie123710503pommie_
pommies133712843pommies
poofter1237163poofter
poorer82613993po_orer
poorest9312773po_orest
poppet92717323po_ppet
pore66451263po__re_
pored85234513po__red
pores75849033po__res
porrect1159743po_rrect
port66059633po__r_t
posset84923253po_sset
poufed12449713pouf_ed
pouffe14448263pouffe_
pouffed16365953pouffed
pouffes15408123pouffes
poured95116743po_ured
pourer84516043po_urer
powered132911643powered
soleret7321233soleret
sombre10729473sombre_
somerset10411073somerset

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.390458182.1
2DLD Change Limit134027586.67320085.0
3Display Results58580.0301933.3
 (SQL Overall)178691587.09325192.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.