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

103 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
dithers11401615(None) 
cithers124315771cithers
diethers1257451diethers
ditchers143610361ditchers
dither104417681dither_
dithery14318941dithery
mithers123516731mithers
tithers104216731tithers
withers134417751withers
zithers193911971zithers
aethers103614942aethers
anthers103715202anthers
bathers124720362bathers
biters83925242bit_ers
bitters94920362bitters
blithers134711232blithers
bothers124317752bothers
ciphers14379992ciphers
citers85022982cit_ers
cither114616682cither_
cithern12489912cithern
citherns13338872citherns
dashers115016862dashers
daters74827372dat_ers
deters74724682det_ers
dialers83614302dialers
diapers104713912diapers
dibbers124013172dibbers
dicers94720742di_cers
dickers144117662dickers
dieters83216432dieters
diether1147442diether_
differs14339972differs
diggers104413392diggers
dikers114418792di_kers
dimers94321092di_mers
dimmers123811562dimmers
diners75525952di_ners
dingers94321382dingers
dinners83915442dinners
dippers123615182dippers
dishes104622652dishe_s
ditcher134012002ditcher_
ditches133215712ditche_s
dites66339152dit_e_s
ditheism1446052ditheism
ditheist1249492ditheist
dithered13189292dithered
ditherer12187762ditherer
ditherers13196682ditherers
ditzes163212422ditze_s
divers105024962di_vers
doters74423912dot_ers
dotters83715972dotters
druthers1275792druthers
either94517422either_
ethers94518412_ethers
fathers133916502fathers
fishers134714722fishers
fitters104517752fitters
gathers114315072gathers
hitchers16379992hitchers
hither124417252hither_
hitters104717592hitters
ither84617602_ither_
jitters144314472jitters
kiters105218592kit_ers
kithes135016652kithe_s
lathers104321882lathers
liters65429882lit_ers
lither94520952lither_
litters73422572litters
miters84328782mit_ers
mither114218562mither_
mothers123717622mothers
niters64624212nit_ers
others93918002_others
pishers123815752pishers
pitchers153211482pitchers
pitiers93812652pitiers
pothers123818622pothers
ritters74020622ritters
sighers113712182sighers
sithens1039382sithens
sitters74221552sitters
slithers114212952slithers
smithers13369792smithers
swithers144310532swithers
tethers103815312tethers
titers64526412tit_ers
titfers10318932titfers
tither94920282tither_
tithes94720212tithe_s
titters74219622titters
wethers135214692wethers
wishers133215212wishers
wither124321352wither_
withes124620842withe_s
writhers14398982writhers
wuthers133711522wuthers
zither183813082zither_
zithern19447022zithern
zitherns20376132zitherns

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 Limit1076711033.40631612.2
3Display Results1031030.0333121.2
 (SQL Overall)1786911033.56250165.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.