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

169 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
why12692001(None) 
shy96728191shy
thy97022911thy
way96757661way
wha96422071wha
whey135018711whey
who95526771who
whys137011661whys
wry96524701wry
aby810238062aby
achy126316092achy
ah513868792ah_
aha611246642aha
ahi68040232ahi
ahoy101919182ahoy
ahs68644822ahs
any68440492any
ashy107717352ashy
away108024222away
awny105919302awny
awry107619682awry
ay511773892_ay
bay89661642bay
bey86645422bey
boy87753562boy
buy86436542buy
by77529232_by
cay87155982cay
chay124924872chay
chi86228652chi
coy810557552coy
cry89726242cry
day76254112day
dey77243372dey
dry76526032dry
eh58339962eh_
fay97454862fay
fey95940882fey
fly97124952fly
foy96044262foy
fry96226502fry
gay76856492gay
gey75738302gey
ghi77019882ghi
goy77844552goy
guy75728942guy
ha510259942_ha
hay97358772hay
he58151952_he
hey96741062hey
hi57947582_hi
hm78126732_hm
ho510258272_ho
hoy97447912hoy
hyp117822462_hyp
icy86322122icy
ivy96317442ivy
jay136242672jay
joy137036362joy
kay106745542kay
key105833332key
khi106318302khi
lay68865352lay
ley66246812ley
may88757632may
mho86624622mho
my78125652_my
nay66952772nay
oh57447002oh_
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oxy136320982oxy
oy58950132_oy
pay88461182pay
phi86524202phi
pht86030522pht
ply86323552ply
pry85728052pry
ray66361992ray
rho65924832rho
say67264762say
sh56828522sh_
sha69837782sha
shay107133342shay
she66837692she
shh97121072shh
sky106420992sky
sly66228562sly
soy67851452soy
spy86023742spy
sty66227312sty
sway107128232sway
the67436052the
they107223752they
tho67433962tho
toy69655192toy
try66529672try
uh57429852uh_
wab87051832wab
wad77053892wad
wady115324992wady
wae67556952wae
wag76451752wag
waly105830902waly
wan66761942wan
wany106432362wany
wap86553372wap
war67262422war
wary106740012wary
was68767562was
washy145911842washy
wat67378922wat
wavy136620472wavy
waw97046382waw
wax137041182wax
waxy175918202waxy
ways107737952ways
we57043452w_e
web85735562web
wed75843622wed
wee66760812wee
wen66249602wen
wet65966622wet
wham125321692wham
whap125119642whap
what105434072what
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
wheys145911552wheys
whid115418872whid
whig115516422whig
whim126220532whim
whin105225692whin
whiny144915572whiny
whip125521842whip
whir105519282whir
whit104834172whit
whity145513472whity
whiz195919942whiz
whoa106615202whoa
whom127018182whom
whop125520922whop
whup125714162whup
wig76740382wig
wily106428812wily
win66456292win
winy107034322winy
wiry106422832wiry
wis66552332wis
wit66563772wit
withy144813762withy
wiz156434152wiz
wo510447762w_o
woe66651242woe
wog76242732wog
wok106334172wok
won66252062won
woo66949802woo
wop87145132wop
wos66953532wos
wot610467482wot
wow96643472wow
wud76227152wud
wye96331972wye
wyn95921442wyn
yay96948712yay

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 Filter178691140840.250714764.0
2DLD Change Limit140841690.78018056.4
3Display Results1691690.0335121.2
 (SQL Overall)1786911691.063168100.7
 
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.