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

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
banty10662400(None) 
bandy114824181bandy
batty105422241batty
bawty135614101bawty
canty105226801canty
janty156816961janty
panty105929301panty
ant37270792_ant_
anta46839582_anta
ante46538902_ante
anti45536362_anti
ants47243472_ants
antsy85712792_antsy
any68440492_an_y
arty77531312_arty
aunty85919812aunty
baby116723682ba_by
baddy125016022baddy
badly114918762badly
baffy165511922baffy
baggy125615682baggy
baht96740012baht_
bahts105617802bahts
bait66556002bait_
baith108023132baith
baits76630582baits
baldy115518932baldy
balky145418242balky
bally105530102bally
balmy125217472balmy
ban58366842ban__
banal75925992banal
banco94019392banco
band76740912ban_d
banda85223102banda
bands85233422bands
bane65250432ban_e
baned85436352baned
banes74945582banes
bang74837002ban_g
bangs85627772bangs
bani65334962ban_i
banjo143812442banjo
bank105835752ban_k
banks115527902banks
banns75321232banns
bans66555142ban_s
bantam10314062bantam
banter84825332banter
barky145721612barky
barmy125218762barmy
barney115314452barney
barny105821732barny
bassy1012917102bassy
bast66362412bast_
baste74829982baste
basts75936932basts
bat510988952ba_t_
bate66552422ba_te
bath95940082ba_th
bats66962332ba_ts
batt65053872ba_tt
batts76727562batts
battu75216612battu
bawdy147513282bawdy
bay89661642ba__y
beauty115410162beauty
bendy115017252bendy
benny105217362benny
bent67759912bent_
bento75922952bento
bents76033692bents
bint67355042bint_
bints76130182bints
bitty106119172bitty
blasty115611052blasty
boney105227312boney
bonny105816622bonny
bony96732082bon_y
booty106125912booty
borty105522832borty
bounty113411072bounty
brandy124712062brandy
branny115111832branny
brant74742172brant_
brants85723052brants
bratty1159682bratty
bunny104715802bunny
bunt65850852bunt_
bunts75729802bunts
busty105621012busty
butty104020112butty
candy115119822candy
canny105817692canny
cant66362032cant_
canto74931012canto
cants77036942cants
catty104520412catty
chanty145215822chanty
dainty105311472dainty
dandy104416702dandy
fancy134615482fancy
fanny114816042fanny
fatty115117412fatty
gantry103810112gantry
handy125520872handy
hanky155418292hanky
hant75461592hant_
hants86335402hants
hasty115718762hasty
jaunty16388512jaunty
laity85318902laity
lanky125517482lanky
linty87126562linty
malty106721702malty
mangy115021242mangy
manly105022952manly
manta75629912manta
many95731862man_y
minty106323902minty
nancy105214922nancy
nanny84813812nanny
nasty85717282nasty
natty85719142natty
painty114714752painty
pandy115021172pandy
pansy105717972pansy
pant66061262pant_
panto76129412panto
pantry115014102pantry
pants76536922pants
party106630612party
pasty105725052pasty
patty104723612patty
paty95234562pa_ty
punty106021612punty
randy95022082randy
rangy95320382rangy
rant45864682rant_
rants55935342rants
ratty84819592ratty
runty86119042runty
salty85524382salty
sandy94221132sandy
sanity9316202sanity
santo56227282santo
scanty114014662scanty
shanty124715122shanty
slanty95114842slanty
tangy94519932tangy
tansy84514932tansy
tanto55724942tanto
tarty86328182tarty
tasty84820312tasty
tatty84720182tatty
tenty86121602tenty
vanity12311932vanity
vasty116215922vasty
vaunty12409062vaunty
waney115120322waney
wanly115118022wanly
want76156172want_
wants87932212wants
wany106432362wan_y
warty119323822warty
zany167316992zan_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.310576422.6
2DLD Change Limit538001661.61033416.1
3Display Results1661660.0463608.7
 (SQL Overall)1786911661.96690890.6
 
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.