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 “millers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
millers9362134(None) 
billers94720831billers
fillers104320211fillers
gillers84216901gillers
hillers103718731hillers
killers114215581killers
milers84625161mi_lers
milkers134411611milkers
miller84625411miller_
milles84526561mille_s
millets94216841millets
milliers102611901milliers
milters93619091milters
mullers93217301mullers
sillers73822101sillers
tillers73418741tillers
willers103517911willers
ballers94421012ballers
bilkers134711862bilkers
biller84923482biller_
billets94516152billets
birlers93813002birlers
callers94221962callers
chillers133710922chillers
cullers93418852cullers
dialers83614302dialers
diallers957772diallers
drillers9429722drillers
fallers103917992fallers
fellers104117542fellers
filers94623722fi_lers
filler94623622filler_
filles94224522fille_s
fillets103414752fillets
filmers124211292filmers
filters103816552filters
frillers11349872frillers
fullers103817372fullers
gilders94212462gilders
giller74519732giller_
grillers93810812grillers
hellers103619832hellers
hiller94421632hiller_
hollers103818232hollers
hullers103616262hullers
idlers74012812_idlers
iller54821292_iller_
jilters144211962jilters
killer104917952killer_
kilters113813602kilters
lollers72713792lollers
lullers73213352lullers
mailers94420332mailers
mailless10248582mailless
mallees93315972mallees
mallets93318492mallets
malleus92911312malleus
maulers94213302maulers
melders103213912melders
melters93918312melters
mewlers12288982mewlers
middlers123410192middlers
midlegs1156322midlegs
mildens10339932mildens
milder93818452milder_
mildews13365882mildews
miler75733062mi_ler_
miles74645072mi_le_s
milieus939802milieus
milker124814322milker_
milkless1434772milkless
mille75029132mille__
milled94326172mille_d
millet84030742mille_t
millier93716702millier_
milliners11289952milliners
mills75435052mill__s
milnebs11113792milnebs
milreis937322milreis
milter84921232milter_
mimers105520182mi_mers
mincers113714852mincers
minders103720122minders
miners84126632mi_ners
minglers113011292minglers
minters93822472minters
misers85025702mi_sers
misters93927512misters
miters84328782mi_ters
mithers123516732mithers
mixers154513562mi_xers
moilers93615202moilers
molders103315552molders
molters93816972molters
mullens93611312mullens
muller83820352muller_
mullets93614782mullets
mulleys12299202mulleys
oilers64721192oi_lers
pilfers1238962pilfers
pillars9313492pillars
pollers93420022pollers
pullers93618482pullers
riflers103512192riflers
rilles64725502rille_s
rillets74216152rillets
rollers73117472rollers
sellers73721312sellers
sidlers83414232sidlers
siller64026062siller_
silvers104714042silvers
smellers10329762smellers
smilers94113852smi_lers
spillers103311702spillers
swillers11299112swillers
tellers73717592tellers
tilers63523502ti_lers
tiller64222542tiller_
tilters73315952tilters
tollers73217462tollers
trillers83613492trillers
wilders113513502wilders
willer94021062willer_
willets104414322willets
yellers103912952yellers

Search took 4 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 Filter1786911076710.1231452772.4
2DLD Change Limit1076711253.01635699.9
3Display Results1251250.0462717.4
 (SQL Overall)1786911253.18556103.9
 
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.