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

139 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
withes12462084(None) 
kithes135016651kithes
tithes94720211tithes
wiches144418751wiches
wishes124920951wishes
witches152715791witches
wites85536961wit_es
withe115220231withe_
withed134416231withed
wither124321351wither
withers134417751withers
withies133913541withies
writhes134811701writhes
aitches123014362aitches
bathes116524832bathes
bitches144117062bitches
bites75641172bit_es
cites74435592cit_es
cither114616682cither
cithers124315772cithers
cities84524852cities
dishes104622652dishes
ditches133215712ditches
dites66339152dit_es
dither104417682dither
dithers114016152dithers
ditzes163212422ditzes
either94517422either
fiches145219532fiches
fishes125221342fishes
fitches153516192fitches
gites65630182git_es
hitches153616272hitches
hither124417252hither
itches114916212_itches
ither84617602_ither
kites95432552kit_es
kithe125917462kithe_
kithed144613012kithed
kiths125814982kith_s
kythes16499132kythes
lathes95127502lathes
lethes94818082lethes
liches114724292liches
lithe84922012lithe_
lither94520952lither
lithest10513912lithest
lithos94212552lithos
litres65220392litres
miches134320732miches
mites75141802mit_es
mither114218562mither
mithers123516732mithers
mitres83922072mitres
niches114419142niches
nites55736342nit_es
nitres65519332nitres
pishes114722102pishes
pitches143617752pitches
pithed124615612pithed
piths105817542pith_s
pities83828082pities
riches115022082riches
rites54442552rit_es
ritzes154812942ritzes
sites56045432sit_es
sithens1039382sithens
swathes134115512swathes
swishes133411372swishes
switches16159132switches
swithe124010682swithe_
swither133710992swither
swithers144310532swithers
tithe85319702tithe_
tithed104115592tithed
tither94920282tither
tithers104216732tithers
titles63719922titles
titres64718932titres
twitches16156372twitches
tythes12419702tythes
washes124425492washes
watches153017372watches
wether123315392wether
wethers135214692wethers
whishes16309442whishes
whites123919882whit_es
whither163510252whither
whities133113252whities
wides94832832wi_des
widths1335122width_s
wifes114522562wi_fes
wights133315782wights
wiles85437872wi_les
winces114819112winces
winches154714372winches
wines85546862wi_nes
winoes94317012winoes
wintles103414982wintles
winzes184313052winzes
wipes104827082wi_pes
wires86034912wi_res
wises85633192wi_ses
wished134417512wished
wisher123617062wisher
wishers133215212wishers
wisses94619602wisses
witans93412932witans
witched163012192witched
wite75443282wit_e_
wited94727142wit_ed
with105730482with__
withal1238932withal
withier132910492withier
withiest142411242withiest
within123611382within
withins133511692withins
withy144813762with_y
witless103310982witless
witness103010012witness
witney12356842witney
witneys13274722witneys
wits76044882wit__s
witted104216812witted
wives115328922wi_ves
wizes174723342wi_zes
wizzes175110772wizzes
writes94420332writ_es
writhe125310702writhe_
writhed14389622writhed
writhen13407862writhen
writher134010852writher
writhers14398982writhers
wuther124511612wuther
wuthers133711522wuthers
wyches17387912wyches
wytes114113432wyt_es
zither183813082zither
zithers193911972zithers

Search took 4 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 Filter178691825510.376475242.0
2DLD Change Limit825511392.73330205.3
3Display Results1391390.0463021.7
 (SQL Overall)1786911393.15556637.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.