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

276 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
dismay1222947(None) 
dismal92412241dismal
dismays13237431dismays
desman9311692desman
digamy1335892digamy
dimly114913482di_mly
disbar938512disbar
dishy125712352dis_hy
dismally1446512dismally
dismals102010242dismals
dismast10311232dismast
dismayed1535742dismayed
disme85716242dism_e
dismes95617672dismes
display1336662display
distal73615772distal
kismat123011672kismat
mislay113510682mislay
missay114112142missay
aidman92410623aidman
airman82414223airman
airway1237693airway
assay8710283_assay
bigamy1436343bigamy
bima86723833bi_ma_
bimah127013273bi_mah
bimas95521743bi_mas
bitmap1235613bitmap
busman10310253busman
cissy104811073cis_sy
daisy95915313dais__y
daman84821163d_aman
damar84117743d_amar
dammar11438903dammar
dashy125612383das_hy
day76254113d___ay
daysman1335053daysman
decay114718483d_ecay
deejay1734523deejay
defray1337643defray
deism84116033deism__
deisms94411043deism_s
delay94820633d_elay
demy105422853d_em_y
deray95024183d_eray
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
descry1256183descry
deskman1444323deskman
desmans1039003desmans
desmid1048363desmid
desoxy1744623desoxy
dial55935063di__al
diamin9312523diamin
diary95016973di_ary
dicey114819333di_cey
dickey165913523dickey
dicky154816243di_cky
dicta84915633dicta_
dicty115116293di_cty
diddly12389573diddly
didy99121513di__dy
dietary1158663dietary
dikey135116423di_key
diktat11310693diktat
dilly94923783di_lly
dim68146493di_m__
dime76237643di_m_e
dimer85625603di_mer
dimes85833043di_mes
dimity12310473dimity
dimmed124110323dimmed
dimmer114112613dimmer
dimply14339743dimply
dims75435023di_m_s
dinar66319893di_nar
dingey114914053dingey
dinghy14476963dinghy
dingy105721263di_ngy
dinkey144812763dinkey
dinkly144311083dinkly
dinky135819373di_nky
dioecy1235543dioecy
dioxan1465773dioxan
dipody1336363dipody
dippy135111543di_ppy
dipsas9359893dipsas
diquat1639763diquat
diram84419473di_ram
dirams94413703dirams
direly10311563direly
dirham12378273dirham
dirty95617803di_rty
dis46459893dis___
disarm9310473disarm
disarray1244833disarray
disband1138243disband
disbars10310323disbars
disbud10165713disbud
disc76123233dis__c
discant103017263discant
discard11310213discard
discase102912863discase
disced104914653disced
disci85815023dis_ci
disco85616073dis_co
discos94915213discos
discs85316263dis_cs
discus94512113discus
disdain938513disdain
disease83213843disease
diseur738843diseur
dish86328333dis__h
dished114318713dished
dishes104622653dishes
dishpan13105523dishpan
dishrag1246273dishrag
disk96625833dis__k
disked125015763disked
disks105417473dis_ks
dismaler1137903dismaler
dismasts1137513dismasts
dismaying1656823dismaying
dismiss1038153dismiss
disobey1346243disobey
disomic1238763disomic
disown1036953disown
dispart101115283dispart
dispel9310323dispel
displays1446293displays
disrate81418523disrate
diss56434483dis__s
dissave1139413dissave
disseat83816923disseat
dissed85220183dissed
disses75225963disses
distaff1467683distaff
distain8313783distain
distally1239553distally
distant83519953distant
distil73616433distil
disuse74012843disuse
dita56032523di_ta_
ditas65923673di_tas
ditsy95612563di_tsy
dittany1135653dittany
ditty95019293di_tty
ditzy186513283di_tzy
diva85920883di_va_
divan96114843di_van
divas95418583di_vas
divvy15356483di_vvy
diwan95712553di_wan
dizzy177410853di_zzy
dogma96112463dogma_
dogmas105011243dogmas
dolma86214173dolma_
dolman95312403dolman
dolmas95213043dolmas
domal85619203d_omal
doomy116018263doom_y
dormy115817473dorm_y
dossal75510303dossal
douma85817703douma_
doumas95314813doumas
drama85117423drama_
dramady1443563dramady
dramas95814663dramas
dray85428093d__ray
dreamy12509993dreamy
drumly1235703drumly
duma75524453d_uma_
dumas85420433d_umas
dumky154511343d_umky
dummy134712783d_ummy
dumpy135414753d_umpy
dusky135213043dus_ky
dustman1044683dustman
dusty96018323dus_ty
essay867623_essay
filmy136114043film_y
firman112211343firman
firmly1436663firmly
fiscal1139333fiscal
fishway1943813fishway
fishy146011663fis_hy
gamay116419113_gamay
gasman92911743gasman
gimmal11247513gimmal
gimpy135212233gi_mpy
gismo848863gism_o
gismos957183gismos
hiemal11339503hiemal
hissy116112123his_sy
hitman112710223hitman
imam81718333_i_mam
immy114611833_i_mmy
inlay85214323_inlay
isba61310883_isba_
isbas71010403_isbas
ism56322383_ism__
isms66213473_ism_s
jimmy19538503ji_mmy
jimpy195210823ji_mpy
jism135514773jism__
jisms14458003jism_s
kinsman1335963kinsman
kismats13257843kismats
kismet123414623kismet
kissy125510313kis_sy
lima65734133li_ma_
liman75921603li_man
limas75627633li_mas
limby125714073li_mby
limey104721043li_mey
limy95727713li_m_y
may88757633___may
miasma1097563miasma_
miasmal1176743miasmal
miasmas1167743miasmas
midday13327503midday
midway15327153midway
miseat82925713miseat
misery114113543misery
mishap1338873mishap
miskal123710263miskal
mislays12349243mislays
mismade12129353mismade
mismake15139373mismake
mismark1536703mismark
mismate111415353mismate
mismet103722373mismet
misplay1436383misplay
missal84314903missal
missays124010253missays
missy105617563mis_sy
misty106120453mis_ty
oilman839483oilman
oilway1235743oilway
pigmy13299433pigm_y
pima85428653pi_ma_
pimas94725103pi_mas
piscary1437423piscary
pitman102412123pitman
resay85320543res_ay
rimy96621283ri_m_y
risky126311523ris_ky
sashay1238363sashay
say67264763__s_ay
seismal937303seismal
shay107133343__shay
sigma84513833sigma_
sigmas94111363sigmas
sima64730783si_ma_
simar74920813si_mar
simas75727553si_mas
sisal54217733sis_al
sissy85812073sis_sy
slay76436383__slay
spay96631663__spay
stay78333723__stay
sway107128233__sway
tinman82411143tinman
titman82711003titman
unsay83212843uns_ay
visa76323873vis_a_
visas84317653vis_as
vista85416603vista_
vistas94513273vistas
visual938803visual
wimpy155911923wi_mpy
wisely122711713wisely
wisha114910853wisha_
wispy137210973wis_py
yasmak1534593yasmak

Search took 7 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162765.81019400.3
3Display Results2762760.0803450.0
 (SQL Overall)1786912766.28028454.0
 
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.