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 “numberer” 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.

86 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
numberer1218631(None) 
cumberer14266991cumberer
lumberer12177581lumberer
numbered13147141numbered
numberers13165151numberers
cumbered15157952cumbered
cumberers15175992cumberers
limberer12187042limberer
lumbered13188232lumbered
lumberers13196012lumberers
number103913222numb__er
numbers113711242number_s
slumberer13194802slumberer
umbered121510112_umbered
ambeer104511593_ambe_er
austerer838383austerer
blubberer12173453blubberer
bumbler134013233bumb_ler
bumpered1536003bumpered
cambered15128993cambered
clamberer15185263clamberer
cumber124016703cumb__er
cumbers134515393cumber_s
cupbearer1542403cupbearer
dumber114414173dumb__er
encumbered1742643encumbered
fumbler143610813fumb_ler
furbearer1443033furbearer
hammerer15278143hammerer
hamperer15379093hamperer
humbler143411943humb_ler
incumbered1742993incumbered
jabberer1944023jabberer
jumbler183910273jumb_ler
limbered13158113limbered
lumber103817773lumb__er
lumberly1544673lumberly
lumbermen1543163lumbermen
lumbers113815913lumber_s
membered1535903membered
merer75126233__m_erer
mumbler133510913mumb_ler
murderer1145263murderer
mutterer10218913mutterer
nimbler11358053nimb_ler
nubbier11308133nu_bbier
nubblier1254413nubblier
numbed114111443numb__ed
numbering14106993numbering
numberless1442403numberless
numbest1138793numbe_st
numbles113814273numb_les
numeral939083num_eral
numerary1344283num_erary
numeric1158193num_eric
nurturer844473nurturer
pamperer14228333pamperer
puckerer1645793puckerer
putterer10209913putterer
quaverer2054583quaverer
queerer16106503qu_eerer
quiverer2044463quiverer
renumbered15102863renumbered
rubbered1335383rubbered
rubberier1344393rubberier
rumbler113514113rumb_ler
simperer1237173simperer
slumbered14215593slumbered
slumberers14203683slumberers
soberer93110353_soberer
sufferer1436063sufferer
summered1338143summered
summerier1346423summerier
sunderer9310523sunderer
tamperer12248893tamperer
temperer12227723temperer
timbered13137383timbered
tumbler113412823tumb_ler
tumbrel11406853tumb_rel
umbeled12208193_umbeled
umber94617583_umb__er
umbers104215203_umber_s
unnumbered1542203unnumbered
upbearer1243583_upbearer
utterer71910463_utterer
yammerer15225483yammerer

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 Filter1786911461620.1701051123.5
2DLD Change Limit146162867.26620115.9
3Display Results86860.0302866.7
 (SQL Overall)178691867.46623934.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.