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

136 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
todies7422355(None) 
bodies94524141bodies
tidies74721831tidies
toadies82914861toadies
tobies84521021tobies
toddies93011991toddies
tories65435881tories
towies93521191towies
atomies93918362atomies
atonies75320952atonies
atopies92816432atopies
bodes84935102bod_es
bodices12710592bodices
bodied103814582bodied
bogies94724312bogies
boodies103721442boodies
codes86247292cod_es
codices12512582codices
colies84837052colies
conies84338592conies
copies104130302copies
cosies84932152cosies
cozies174521412cozies
didies84621832didies
dies55653522__dies
dobies94422092dobies
dodges96119082dodges
dodoes85716102dodoes
dogies85022252dogies
doodies94218772doodies
dories75232362dories
dowdies123412732dowdies
doxies143917852doxies
eddies83313162eddies
fogies104118062fogies
foodies113416752foodies
gobies95418062gobies
goodies93516992goodies
holies94630032holies
homies114524732homies
hoodies113419832hoodies
howdies142911952howdies
indies73822782indies
iodides93811612iodides
iodids83711152iodids
iodines83616632iodines
iodins74216522iodins
iodise74214942iodise
iodises83413632iodises
iodizes173911722iodizes
ladies75124882ladies
lodes66436912lod_es
lodges86820152lodges
looies65025832looies
lories64933042lories
louies64525102louies
modes85537412mod_es
molies84429512molies
monies83233162monies
movies115118452movies
moxies154317402moxies
noddies93512042noddies
nodes64633492nod_es
nudies75217092nudies
odes57243242_od_es
oldies7314422oldies
oodles73517182oodles
podites103014732podites
pogies94123542pogies
pokies125921332pokies
polies84034582polies
ponies84833462ponies
posies84431432posies
roadies83317442roadies
rodes614039082rod_es
rowdies113112692rowdies
soddies92312852soddies
stodges9309082stodges
stogies8413692stogies
stories7324272stories
studies82413862studies
tardies84225862tardies
taxies135817332taxies
teddies92711282teddies
tides64830152tid_es
tidied83613272tidied
tidier73515112tidier
tidiers8389772tidiers
tidiest83514872tidiest
ties45248312t__ies
toadied9248012toadied
todays10458102todays
toddles93211532toddles
tods56141842tod__s
toes46956442to__es
toffies133210212toffies
togues76014242togues
toiles63923512toiles
toils54527492to_ils
toits55327472to_its
tokes95234972to_kes
toles55147132to_les
tomes76037382to_mes
tommies113812982tommies
tones56048662to_nes
tonics83617862tonics
tonier65520712tonier
toniest73218902toniest
tonnes65320852tonnes
toonies73719882toonies
topees85519702topees
topes76941762to_pes
tophes115218422tophes
topics104714582topics
topis76025832topi_s
toques154612352toques
tores55352672to_res
torics85118352torics
torses64727952torses
tortes64826052tortes
toshes94520102toshes
tosses65225392tosses
totes55139682to_tes
touses64229672touses
towie85821872towie_
townies103113622townies
toxics153910202toxics
toxines142912262toxines
toxins133314282toxins
tries55742812t_ries
undies73821962undies
wadies105121202wadies
wodges117413682wodges
woodies113517152woodies
yodles103714332yodles
yowies123913732yowies

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 Filter178691825510.406440125.6
2DLD Change Limit825511362.87628703.4
3Display Results1361360.0462956.5
 (SQL Overall)1786911363.32853693.2
 
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.