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 “weka” with Change Limit: [1] [2] [3]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

94 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
weka11701387(None) 
weak117126301weak
wekas123911791wekas
beak106534382beak
bema85825252bema
beta66234132beta
ceca84820782ceca
deke95228762deke
deva85720982deva
eek77935102eek_
eke75630092_eke
era35741502_era
eta35834192_eta
feta76528902feta
geta56627442geta
ilka87215152ilka
ka69145082__ka
kaka76518682kaka
kea76540912ke_a
lea37660182le_a
leak86233712leak
lek75640302lek_
leke85527402leke
leks85427602leks
leku86519912leku
leva77020712leva
mega77620872mega
mesa67025482mesa
meta65932412meta
nema65522522nema
oka76926802_oka
pea56657242pe_a
peak106535202peak
pekan111613972pekan
peke105926202peke
pika106322952pika
sea36161292se_a
sera46141392sera
seta45637312seta
sika86021322sika
ska76925862_ska
taka87623592taka
tea37353322te_a
teak85930842teak
tela45532972tela
tepa66021682tepa
tweak1257752tweak
vela75725542vela
vena76126292vena
vera76828842vera
wake114935702wake
we57043452we__
weal75838682weal
wean75734352wean
wear75836722wear
web85735562we_b
webs96622122webs
wed75843622we_d
weds86628932weds
wee66760812we_e
weed85637512weed
week116428152week
weeks125017862weeks
weel75834082weel
ween75835462ween
weep95131652weep
weer75535092weer
wees76249122wees
weet75254152weet
weft105435012weft
weir76019922weir
weld84727732weld
well75832042well
welt75547862welt
wen66249602we_n
wend85330452wend
wens76337932wens
went76051872went
wept95635052wept
were76238332were
wert79749822wert
west75748082west
wet65966622we_t
wets75940292wets
wha96422072w_ha
whoa106615202whoa
wok106334172wok_
woke115527962woke
woks116224902woks
wreak125513272wreak
yea66445752ye_a
zek167323162zek_
zeks175815062zeks
zeta135121642zeta

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 Filter178691298720.330541487.9
2DLD Change Limit29872940.86034734.9
3Display Results94940.0137230.8
 (SQL Overall)178691941.203148537.8
 
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.