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

143 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
restful103862(None) 
jestful1745331jestful
zestful1945241zestful
chestful1644242chestful
feastful1444922feastful
fistful1365902fistful
fretful1346142fre_tful
kistful1465302kistful
lustful1045282lustful
resentful1244262resentful
restfully1545552restfully
restuff1346952restuff
resultful1252462resultful
tristful1144932tristful
trustful1144372trustful
unrestful1243442unrestful
wistful1365712wistful
armsful1284093arms_ful
artful968273_artful
bashful1556553bashful
bestial9311643bestial
bestud9439303best_ud
boastful1344853boastful
boatful1236283boatful
cestus84412913cest_us
chestfuls1742883chestfuls
crestal9312133crest_al
deathful1544013deathful
dishful1455433dishful
dreadful1343223dreadful
dreamful1452963dreamful
earful958963_earful
easeful1037293easeful
estral64716513_estral
estrual7367933_estrual
estrum81810513_estrum
estrus61912113_estrus
eventful1443563eventful
eyeful1235903_eyeful
factful1536373factful
fearful1345593fearful
festal94213563fest_al
fistfuls1454563fistfuls
fitful1256333_fitful
fruitful1443553fruitful
ghastful1543303ghastful
hasteful14105253hasteful
hatful12108743_hatful
hatsful13106193hatsful
headful1445563headful
heedful1444313heedful
helpful1543963helpful
hurtful1344853hurtful
hushful1644333hushful
ireful948713ire__ful
kestrel1137113kestrel
kistfuls1553833kistfuls
menseful1344043menseful
moistful1343853moistful
museful1245883museful
needful1143863needful
oestrum9177783oestrum
oestrus7169583oestrus
potful1138083_potful
poutful1236743poutful
pushful1544493pushful
rackful1645873rackful
rectal84418133rect_al
rectum103411283rect_um
rectus83314633rect_us
redtail858713redtail
refel84920813re__fel
refuel93912623re__fuel
regretful1352723regretful
rental63922023rent_al
reposeful1452593reposeful
resail64418733res_ail
rescue8313003res_cue
reseal64819643res_eal
reseau64216213reseau_
reseaus74012153reseaus
reseaux14326233reseaux
resell64215203res_ell
residua8286623residua
residual9245443residual
residue8689863residue
resift94017723resif_t
resifts10378703resifts
respectful1752933respectful
respell947023respell
respool937643respool
rest46459843rest___
restable101618443restable
restack1339433restack
restaff1339013restaff
restaffs1444783restaffs
restage83316193restage
restamp1146483restamp
restart7320033restart
restate73824883restate
rested74430783rest_ed
rester63832433rest_er
resters74130403resters
restfuller1363253restfuller
resting85031183resting
restive10315933restive
restock1338673restock
restoke116113903restoke
restoral8810983restoral
restore75822983restore
restruck1445223restruck
restrung9176443restrung
rests54935873rest__s
restudy1144763restudy
restuffs1444193restuffs
restyle1038763restyle
result6318223res__ult
retail65522073re_tail
retell63813643re_tell
retial64724993re_tial
retool63914483re_tool
retral64419743re_tral
rightful1544233rightful
roomful1244183roomful
rostral7311333rostral
rostrum947213rostrum
rueful948203r_ueful
ruthful1344503ruthful
senseful1144593senseful
stressful1252663stressful
tactful1236163tactful
tasteful11115223tasteful
tearful1046033tearful
teenful1045563teenful
thrustful1552273thrustful
useful947013_useful
vatful12107083_vatful
vestal94615573vest_al
vestral104111013vestral
wasteful14104933wasteful
wishful1664503wishful
wreckful2042443wreckful
zestfully2443913zestfully

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271437.12618808.2
3Display Results1431430.0602383.3
 (SQL Overall)1786911437.60923484.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.