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

123 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
patly10502058(None) 
aptly105111811aptly
fatly115716801fatly
pally105727121pally
paly95835531pa_ly
partly116315471partly
patsy105717201patsy
patty104723611patty
paty95234561pat_y
ably99725132_ably
agly86821802_agly
ally76935642_ally
apathy1437032apathy
apply125111392apply
badly114918762badly
bally105530102bally
batty105422242batty
catty104520412catty
daftly1335442daftly
daily95922332daily
dally95324742dally
early85324122early
fatty115117412fatty
featly123711752featly
fitly115114972fitly
flatly123110212flatly
gaily95020972gaily
gally95026172gally
gayly124513092gayly
haply135915062haply
hotly115815482hotly
lastly93310872lastly
lately93413842lately
lathy115215062lathy
laxly15610102laxly
madly115218132madly
malty106721702malty
manly105022952manly
marly106925612marly
matey107022662matey
natty85719142natty
neatly93812482neatly
pacey126720282pacey
packly17228332packly
pacy115328682pa_cy
paddy125913592paddy
padle84522342padle
pail66141832pail_
pails75833062pails
pal56761672pa_l_
pale66055012pa_le
palely11311932palely
pall65039342pa_ll
palls74332562palls
palm85331362pa_lm
palmy126016732palmy
palp85828572pa_lp
pals66951352pa_ls
palsy105417462palsy
paltry114910402paltry
pandy115021172pandy
pansy105717972pansy
pantry115014102pantry
panty105929302panty
pappy114713802pappy
pardy115523952pardy
parlay113713992parlay
parle75836162parle
parley116718362parley
parry105323752parry
party106630612party
pastry114913032pastry
pasty105725052pasty
pat58089462pat__
patch125221222patch
patchy16509572patchy
pate65350462pat_e
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
path99134912pat_h
paths105521382paths
patin76832852patin
patio74426352patio
pats66460852pat_s
pawky173810152pawky
pawl95123262pawl_
pawls105617662pawls
pay88461182pa__y
pearly116414842pearly
peartly1267452peartly
peaty105725692peat_y
pertly115312552pertly
petty105320292petty
pily96132732p_ily
pithy135614462pithy
pity96031932pit_y
platy105021662plat_y
ply86323552p__ly
poly96235152p_oly
portly114713402portly
potsy105815612potsy
potty105621002potty
putty104721402putty
rally84725902rally
raptly11338912raptly
rattly94111542rattly
ratty84819592ratty
rawly115115832rawly
sadly94519122sadly
sally85129712sally
salty85524382salty
satay84718462satay
tally84526862tally
tartly96014022tartly
tatty84720182tatty
tautly9499502tautly
vastly12508722vastly
wally114625092wally
waly105830902wa_ly
wanly115118022wanly
wetly114511712wetly

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001231.43637465.2
3Display Results1231230.0462673.9
 (SQL Overall)1786911231.79599549.3
 
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.