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

138 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
wanly11511802(None) 
manly105022941manly
wally114625091wally
waly105830901wa_ly
waney115120321waney
wany106432351wan_y
ably99725132_ably
agly86821802_agly
ally76935642_ally
any68440482_an_y
awny105919302awn_y
badly114918762badly
bally105530102bally
bandy114824182bandy
banty106624002banty
candy115119822candy
canny105817692canny
canty105226802canty
daily95922332daily
dally95324742dally
dandy104416702dandy
dangly114212262dangly
dankly14419462dankly
early85324122early
fancy134615482fancy
fanny114816042fanny
fatly115716802fatly
gaily95020972gaily
gainly1049322gainly
gally95026172gally
gangly113911582gangly
gayly124513092gayly
handy125520872handy
hanky155418292hanky
haply135915062haply
inly75622212_inly
jangly174310602jangly
janty156816962janty
lanely93914482lanely
lankly13439622lankly
lanky125517482lanky
laxly15610102laxly
leanly93811502leanly
madly115218132madly
mainly11411492mainly
mangy115021232mangy
many95731842man_y
marly106925612marly
meanly115412042meanly
nancy105214922nancy
nanny84813812nanny
only75319722_only
pally105727122pally
paly95835532pa_ly
pandy115021172pandy
pansy105717972pansy
panty105929302panty
patly105020582patly
rally84725902rally
randy95022082randy
rangy95320382rangy
rankly133910452rankly
rawly115115832rawly
sadly94519122sadly
sally85129712sally
sandy94221132sandy
sanely93114612sanely
sonly85718052sonly
swanky16447972swanky
swanny12336822swanny
tally84526862tally
tangly104413912tangly
tangy94519932tangy
tansy84514932tansy
twangy13386982twangy
twanky16445772twanky
vainly1258502vainly
wabbly16348362wabbly
wacky174714932wacky
waddly14478722waddly
waddy135312992waddy
wady115324992wa_dy
waffly18305432waffly
waggly14347292waggly
wail75238822wail_
wails86631482wails
wale74546432wa_le
walk115625612wa_lk
wall76236102wa_ll
walla85321032walla
walls85529382walls
wambly16388662wambly
wan66761932wan__
wand85833872wan_d
wandle105316662wandle
wands96425482wands
wane76344712wan_e
waned95831782waned
wanes85040882wanes
wangle103817502wangle
wank115632502wan_k
wanks126124482wanks
wans76452262wan_s
want76156162wan_t
wants87932212wants
warily122915092warily
warmly14228062warmly
warty119323822warty
wary106740012wa_ry
washy145911842washy
waspy135410992waspy
waul76927312waul_
wauls86120552wauls
wavey145115542wavey
wavily15219482wavily
wavy136620472wa_vy
wawl105321942wawl_
wawls115416472wawls
waxily19218412waxily
waxy175918202wa_xy
way96757662wa__y
waylay1535452waylay
weakly1636482weakly
welly114620012welly
wenny114412462wenny
wetly114511712wetly
willy115321912willy
wily106428812w_ily
windy126118102windy
winey115325432winey
wingy126521032wingy
winy107034322win_y
womanly1535852womanly
wonky154011772wonky
wooly114417672wooly
wryly14356702wryly
zanily18310182zanily
zany167316982zan_y

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.0931921408.6
2DLD Change Limit538001381.62333148.5
3Display Results1381380.0463000.0
 (SQL Overall)1786911381.762101413.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.