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

184 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
who9552677(None) 
ho510258271_ho
mho86624621mho
oho66534381oho
rho65924831rho
tho67433961tho
wha96422071wha
whoa106615201whoa
whom127018171whom
whop125520921whop
why126920011why
wo510447761w_o
woo66949801woo
abo59045962abo
ado49146872ado
ago48845522ago
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
apo511142122apo
avo68936232avo
azo128233392azo
bio57846072bio
bo410957572_bo
boho96923322boho
boo58163662boo
bro56236602bro
chao95727312chao
chi86228652chi
chon96627792chon
chop116024922chop
chow125820992chow
coho97524492coho
coo59566362coo
dhow116614002dhow
do310155252_do
duo48536142duo
echo96615952echo
ego46726052ego
eh58339962eh_
foh98135892foh
fro65530642fro
ghi77019882ghi
go38748742_go
goo47754772goo
ha510259942_ha
hao67251122hao
he58151952_he
hi57947582_hi
hm78126732_hm
hob87550922_hob
hod76852462_hod
hoe67562722_hoe
hog78049062_hog
hon67759382_hon
hop87554592_hop
hos68364192_hos
hot67776052_hot
how97252432_how
hoy97447912_hoy
jo99539602_jo
khi106318302khi
lo28053442_lo
loo38359822loo
mhos95517772mhos
mo49158482_mo
moo58460512moo
no29353242_no
noh66640642noh
noo37154042noo
oh57447002oh_
ohm86523012ohm
ohs66232312ohs
ono36838032ono
ooh67637092ooh
oxo107322962oxo
phi86524202phi
phon95925382phon
phot95534352phot
pht86030522pht
poh86740532poh
poo57757112poo
pro55837262pro
rhos76319062rhos
sh56828522sh_
sha69837782sha
she66837692she
shh97121072shh
shmo95318092shmo
shod86225052shod
shoe75933432shoe
shog86025132shog
shoo75929882shoo
shop95629832shop
shot76150242shot
show106229182show
shy96728192shy
so28855442_so
tao38358952tao
the67436052the
thio77225412thio
thou76722212thou
thro77726422thro
thy97022912thy
to218858982_to
too38965422too
two67925832two
udo49027302udo
uh57429852uh_
upo58925862upo
wab87051832wab
wad77053892wad
wae67556952wae
wag76451752wag
wahoo112413082wahoo
wan66761932wan
wap86553372wap
war67262422war
was68767562was
wat67378922wat
waw97046382waw
wax137041182wax
way96757662way
we57043452w_e
web85735562web
wed75843622wed
wee66760812wee
wen66249602wen
wet65966622wet
wham125321692wham
whamo135511262whamo
whap125119642whap
what105434072what
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
whid115418872whid
whig115516422whig
whim126220522whim
whin105225692whin
whip125521842whip
whir105519282whir
whit104834172whit
whiz195919942whiz
whole114418092whole
whomp155011322whomp
whoof144612692whoof
whoop134211442whoop
whops135013932whops
whore116018042whore
whorl114612452whorl
whort114623692whort
whose114914532whose
whoso11509222whoso
whup125714162whup
whys137011662whys
wig76740382wig
win66456292win
wino75933612wino
wis66552332wis
wit66563772wit
wiz156434152wiz
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
wood85329382wood
woof106532422woof
wool76427372wool
woos76238802woos
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
wry96524702wry
wud76227152wud
wye96331972wye
wyn95921442wyn
yo59748552_yo
zoo126238912zoo

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.0602978183.3
2DLD Change Limit140841840.37637457.4
3Display Results1841840.0335575.8
 (SQL Overall)1786911840.469381004.3
 
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.