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

214 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
wha9642207(None) 
aha611246641aha
ha510259941_ha
sha69837781sha
wham125321691wham
whap125119641whap
what105434071what
who95526771who
whoa106615201whoa
why126920011why
aa219179952_aa
aah616252962aah
aba512850952aba
aga410447232aga
agha87417302agha
ah513868792ah_
ahi68040232ahi
ahs68644822ahs
ala312463602ala
ama510853302ama
ana39559822ana
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bah87755352bah
boa56954032boa
bra56339462bra
chad105525502chad
chai95929902chai
cham115532312cham
chao95727312chao
chap114928492chap
char95132152char
chat95546132chat
chaw126224632chaw
chay124924872chay
chi86228652chi
chia96026622chia
dah78148982dah
dhak125512032dhak
dhal86719282dhal
eh58339962eh_
epha9310052epha
era35741502era
eta35834192eta
fa510148452_fa
ghat86435282ghat
ghi77019882ghi
goa47343802goa
had77658762_had
hae67364002_hae
hag77255742_hag
hah910655222_hah
haha107821062haha
haj138140602_haj
ham86363282_ham
hao67251122_hao
hap87360052_hap
has67372652_has
hat67289962_hat
haw97153272_haw
hay97358772_hay
he58151952_he
hi57947582_hi
hm78126732_hm
ho510258272_ho
hwan105716892hwan
ka69145082_ka
kea76540912kea
khaf145319602khaf
khan115819142khan
khat116730722khat
khi106318302khi
koa76737772koa
la219261632_la
lea37660182lea
ma410060652_ma
mho86624622mho
moa57249182moa
na28652482_na
nah69847002nah
oba57531552oba
oca56731732oca
oda48133042oda
oh57447002oh_
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oka76926802oka
ora37250832ora
ova66823792ova
pa410456482_pa
pah88853592pah
pea56657242pea
phat95837862phat
phi86524202phi
pht86030522pht
pia56848032pia
pya87023752pya
qua124821972qua
rah68052402rah
rhea75017432rhea
rho65924832rho
ria36745502ria
rya67622012rya
sea36161292sea
sh56828522sh_
shad86230912shad
shag86430562shag
shah105627782shah
sham96436352sham
shat76456592shat
shaw108132552shaw
shay107133342shay
she66837692she
shea76031572shea
shh97121072shh
shwa106014962shwa
shy96728192shy
ska76925862ska
spa55730812spa
ta211662452_ta
tea37353322tea
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
the67436052the
tho67433962tho
thy97022912thy
twa67721642twa
uh57429852uh_
uta37425582uta
via65636242via
wab87051832wab
wad77053892wad
wae67556952wae
wag76451752wag
wan66761932wan
wap86553372wap
war67262422war
was68767562was
wat67378922wat
waw97046382waw
wax137041182wax
way96757662way
we57043452w_e
weak117126302weak
weal75838682weal
wean75734352wean
wear75836722wear
web85735562web
wed75843622wed
wee66760812wee
weka117013872weka
wen66249602wen
wet65966622wet
whack174813022whack
whale115517432whale
whamo135511262whamo
whams135515642whams
whang124813382whang
whaps135115162whaps
wharf14315822wharf
whats117718992whats
whaup13458882whaup
wheal115716182wheal
wheat114924572wheat
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
whid115418872whid
whig115516422whig
whim126220522whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
whom127018172whom
whop125520922whop
whup125714162whup
whys137011662whys
wig76740382wig
win66456292win
wis66552332wis
wisha114910852wisha
wit66563772wit
wiz156434152wiz
wo510447762w_o
woad85523942woad
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
wrap96821972wrap
wry96524702wry
wud76227152wud
wye96331972wye
wyn95921442wyn
ya510251502_ya
yah99046352yah
yea66445752yea
za1114939202_za
zoa128529992zoa

Search took 1 second 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 Filter178691140840.0632836365.1
2DLD Change Limit140842140.37337758.7
3Display Results2142140.0464652.2
 (SQL Overall)1786912140.482370728.2
 
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.