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

178 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
weskits143474(None) 
weskit1338341weskit_
jesuits1436322jesuits
muskits13278562muskits
resits64725562res_its
skits94721872__skits
welkins1437172welkins
wests85727002wes__ts
wetsuits1143232wetsuits
bankits133410153bankits
baskets135111833baskets
beckets15399823beckets
bedsits1037563bedsits
befits114711503be_fits
bekiss1236373be_kiss
besets85718803bes_ets
besmuts1134683besmuts
besots86415453bes_ots
bestirs9311133bestirs
bests75932613bes__ts
boskets13409473boskets
buskins133310943buskins
caskets133910173caskets
cesspits1243663cesspits
debits94214503de_bits
deceits102810883deceits
demits94918073de_mits
desalts839573desalts
deserts82513053deserts
desist74818813des_ist
desists83611723desists
desks105913073desk__s
desmids1166603desmids
despite10410123despite
despites11410313despites
despots10319683despots
doeskins1344903doeskins
edits65819033_e_dits
emits75421473_e_mits
enskies1138573enskies
escots84211743_escots
eskars10357593_eskars
eskers105312223_eskers
espies83716803_espies
esprits938393_esprits
exits125515913_e_xits
fests85828043fes__ts
gaskets12348153gaskets
gaskins123510773gaskins
gests66028813ges__ts
henbits12177003henbits
hermits12312143hermits
hessite1038993hessite
hessites1138613hessites
hests85829933hes__ts
huskies143212083huskies
jerkies183411583jerkies
jerkins18358253jerkins
jests125922453jes__ts
jesuit1339583jesuit_
kits86441783___kits
legits71313003le_gits
merits8320873me_rits
mesquits19496483mesquits
misfits12279663misfits
mishits122513083mishits
muskets13258643muskets
muskies133614673muskies
muskit122813253muskit_
nests55728003nes__ts
peewits12105873peewits
pekins121812233pe_kins
permits11314003permits
peskier13319113peskier
peskiest142610163peskiest
peskily1635083peskily
pests75933273pes__ts
pewits112810683pe_wits
posits85718713pos_its
rebaits9312573rebaits
recits83621353re_cits
redskins1385873redskins
reedits8511743reedits
reemits9611303reemits
refits94017653re_fits
reknits1137073reknits
remits85622943re_mits
resails74616743resails
reseats74319583reseats
resects94115593resects
resents74221223resents
resets65427613res_ets
reships1239863reships
resids74219153res_ids
resifts10378703resifts
resins64528773res_ins
resist64524533res_ist
resists74414923resists
resit54241043res_it_
resite64128453res_ite
resites74027793res_ites
resorts74817193resorts
respite9513033respite
respites10513243respites
resplits1037723resplits
respots92912763respots
rests54935873res__ts
results739833results
selkies113513353selkies
sennits73811283sennits
sestets7911473sestets
shits84731173__shits
siskins1159583siskins
sits45050213__s_its
skats94621543__skats
skids104615343__skids
skies95026843__skies
skims114517203__skims
skins94723473__skins
skips115616613__skips
skirts104111503__skirts
skis84825303__ski_s
skit85437543__skit_
skite95120063__skite
skites104418043__skites
slits56128853__slits
snits54124833__snits
spits74429553__spits
suits55028053__suits
tekkies1035943tekkies
territs72714503territs
testis64916713testi_s
tests56530193tes__ts
vespids1334613vespids
vests85325983ves__ts
visits9311423vis_its
waits88333523w__aits
wasts87433673was__ts
weakens14367063weakens
weakest1439003weakest
weakish17217173weakish
weakons14287803weakons
wearies103020233wearies
website1235323website
websites1335183websites
wechts1446253we_chts
wedgies123910213wedgies
weeklies1534913weeklies
weeks125017863week__s
weenies102915093weenies
weepies122811743weepies
weets85427723we__ets
weevils1384683weevils
wefts116715493we__fts
weights14409553weights
weirs84316493we__irs
wekas123911793we_k_as
welkin1337313welki_n
wellies103719073wellies
welts85225193we__lts
west75748083wes__t_
westers105221963westers
westing115020273westing
westings12429803westings
wets75940293we___ts
wetsuit1045453wetsuit_
whiskies1835953whiskies
whits115923823w__hits
wickets164010943wickets
wineskins1644213wineskins
wisents10249063wisents
wists86728523wis__ts
wits76044883w___its
worrits10258683worrits
wrests95313083wres__ts
writs86624383w__rits
wussies103411083wussies
zests145419743zes__ts

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.410435831.7
2DLD Change Limit1340271786.64020184.8
3Display Results1781780.0602966.7
 (SQL Overall)1786911787.11025132.3
 
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.