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

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

166 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
digested1120816(None) 
digester10258431digester
divested13268211divested
degusted1135732degusted
detested10279622detested
devested13239132devested
diester83013682di_ester
dieted83115492di_e_ted
digest84019622digest__
digesters11257882digesters
digestif1396172digestif
digestor10246552digestor
digests93610612digest_s
dighted132511492dig_hted
digressed1245612digressed
directed1238232directed
disgusted1246122disgusted
diverted13199582diverted
egested938122_egested
indigested13103672indigested
ingested10259002ingested
redigested1354112redigested
undigested13123842undigested
agented939423_agented
agisted938203_agisted
arrested939153arrested
attested936293attested
bested94922753__bested
bighted142810923big_hted
bigoted11258403big_oted
bilsted1038033bi_lsted
bimester1236163bimester
bisected1336203bisected
chested133811673_chested
cisted95217523ci__sted
congested1338673congested
crested103416533_crested
defeated132812163defeated
defected15289973defected
degassed11275963degassed
degermed1335453degermed
dejected19307593dejected
deleted93314903dele_ted
delisted10310563delisted
demasted1238763demasted
demented12311273demented
dented84120513d__ented
deserted101012203deserted
desisted1039783desisted
detected12289733detected
detester9239683detester
diastem10318043di_astem
diaster82813313di_aster
dictated1239203dictated
diesel74410403di_es_el
dieseled1035523di_eseled
dieses75218693di_es_es
diesters92513603di_esters
dieter73516773di_e_ter
digestifs1484433digestifs
digesting12208673digesting
digestion1146573digestion
digestive1446243digestive
digestives1545213digestives
digestors11257273digestors
digged104314653dig__ged
digitated1286963digitated
digresses1137863digresses
dilated93115823di_lated
diluted9248933di_luted
dimeter10411893dime_ter
dinette8310013dinette_
dinettes9310193dinettes
dinted84419843di__nted
dipnetted1343353dipnetted
directer1137583directer
direst75024243direst__
disaster949943disaster
disced104914653di__sced
discepted1547523discepted
diseased103011713diseased
disesteem1244623disesteem
dished114318713di__shed
disjected2086353disjected
disked125015763di__sked
dismasted1346833dismasted
disputed1238353disputed
disrated10915573disrated
disseated11711083disseated
dissected13108663dissected
dissed85220183di__ssed
dissented1199723dissented
disserted11109813disserted
distasted1137963distasted
distend93312073di__stend
disused93211033disus_ed
diverged14256883diverged
diverter12238623diverter
divest106820073divest__
divests114510933divest_s
dizened18267333dize_ned
dogeared1145793dogeared
dogsled1035193dog_sled
dopester1137253dopester
dressed93511873d_ressed
dueted84113593d_ue_ted
duetted937023d_uetted
dusted83918373d__usted
fidgeted1443893fidge_ted
figeater1236953figeater
fileted1159093file_ted
finessed12136793finessed
fisted104218703fi__sted
forested12312463forested
gasted84821583__gasted
geste65920693__geste_
gestes75721393__gestes
guested9157713_guested
gusted84316723__gusted
highted152710163hig_hted
histed104420243hi__sted
ideated9310973_ideated
ignited9137623_ignited
infested12249643infested
invested12229693invested
jested144416503__jested
kiester11329973ki_ester
ligated92414143lig_ated
lighted122913503lig_hted
lineated9711063lineated
listed74322833li__sted
migrated121110513migrated
misted93625823mi__sted
molested11178243molested
nested74720063__nested
obtested1135453obtested
pigmented1544063pigmented
pileated112711133pileated
pipestem1443743pipestem
pipetted1335263pipetted
predigested1653073predigested
priested1138393priested
quested17168383_quested
reested82916233_reested
renested92212953renested
rested74430783__rested
retested92212533retested
revested122612243revested
righted122912143rig_hted
rimester1037813rimester
riposted11216933riposted
riveted11258573rive_ted
rivetted12226093rivetted
sidestep1144243sidestep
sighted123111523sig_hted
signeted1035973signeted
suggested1243423suggested
tested74421523__tested
unrested91914513unrested
untested92612413untested
unvested122210223unvested
vested104217353__vested
vignetted1443493vignetted
wisted104120273wi__sted
wrested113410933_wrested
zested164214043__zested

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.1561145455.1
2DLD Change Limit1461621667.50019488.3
3Display Results1661660.0632634.9
 (SQL Overall)1786911667.71923149.5
 
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.