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

244 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
deewan1026755(None) 
deewans11306901deewans
dewan95718041d_ewan
dean56039482d_e_an
deejay1734522deejay
deepen9339192deepen
demean9510562demean
desman9311692desman
dewans105215142d_ewans
dewar95817732d_ewar
dewax165510852d_ewax
diwan95712552d_iwan
leeway1255882leeway
rewan85623662_rewan
seawan94111222seawan
sewan85921292_sewan
ajowan1634893ajowan
ameban1039093ameban
axeman1538103axeman
bean66443863_be_an
bedeman12168843bedeman
bedpan1137583bedpan
been65335783bee__n
beeswax1942403beeswax
began86319573_began
bemean10410683bemean
bemoan10310253bemoan
clean75420413cle_an
crewman1435753crewman
daedal849083daedal
daemon9279593daemon
daman84821163d_aman
dan46859673d___an
dawen95413723d_awen
dawn85624203d_aw_n
deacon9510423deacon
dead65434243d_e_ad
deaden83714323deaden
deadman11238423deadman
deadpan11225233deadpan
deaf85838403d_e_af
deafen10389673deafen
deal56347413d_e_al
deans66131393d_e_ans
dear55343603d_e_ar
debag94212303d_ebag
debar85517863d_ebar
debeak1336763debeak
decaf114919443d_ecaf
decal85523233d_ecal
decane93818873d_ecane
decant93524223d_ecant
decay114718483d_ecay
decern91310953decern
declaw1266703declaw
decuman1236573decuman
dedal75719023d_edal
dedans85915073d_edans
dee47665823dee___
deed65340903dee__d
deeded94615543deeded
deeding103315123deeding
deeds75423763dee_ds
deedy104315893dee_dy
deejays1843433deejays
deem75432893dee__m
deemed104713063deemed
deeming113913123deeming
deems85421773dee_ms
deep76031883dee__p
deepens10307813deepens
deeper93613503deeper
deeply1257013deeply
deeps84921773dee_ps
deer56739023dee__r
deers64930523dee_rs
dees56356633dee__s
deet57356583dee__t
deets65330243dee_ts
defang1137753d_efang
defat95426693d_efat
defeat103817163defeat
defiant11311923defiant
defoam1238563defoam
defrag1136463defrag
defray1337643defray
degas75119163d_egas
dehorn10439653dehorn
deign74312803d_eign
delay94820633d_elay
delead84112343delead
delta66117773delta_
deltas74414823deltas
demand104314253d_emand
demeans1039723demeans
demeton1037683demeton
demon86520313d_emon
den47554343d_e__n
denar65223293d_enar
denial74720513denial
dental74319173dental
dentin73919573dentin
deodand1035713deodand
deodar837713deodar
deplane10311413deplane
derat65044083d_erat
deray95024183d_eray
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
desand84812633d_esand
descant104315593descant
design8408933design
deskman1444323deskman
desmans1039003desmans
destain8412083destain
detain74617383detain
detrain8412253detrain
deva85720983d_eva_
devas96218883d_evas
devein1039143devein
deviant11311313deviant
devon95113683d_evon
dew77139923d_ew__
dewars105117073d_ewars
dewed105020303d_ewed
dewing114115703d_ewing
dewlap1264843dewlap
dews86230603d_ew_s
dewy115419023d_ew_y
dextran1586163dextran
dioxan1465773dioxan
divan96114843d_ivan
diwans105110373d_iwans
dolman95312403dolman
down86427493d_ow_n
drawn95614243draw_n
dread74419023dre_ad
dream85120393dre_am
drear65016903dre_ar
drew86221673drew__
drown95515823drow_n
duenna734593duenna
durian7312003durian
edema8610553edema_
edemas9310503edemas
elan46734243__elan
foeman11311233foeman
freeman1237343freeman
freeway1635603freeway
geegaw1142853geegaw
german9611983german
glean65818203gle_an
gleeman1035363gleeman
gowan95415743_gowan
heehaw1543933heehaw
hetman112510603hetman
hewn106719853_hew_n
hwan105716893__hwan
iceman1037853iceman
jawan15710383_jawan
jean116629283_je_an
jetway19105273jetway
keen84830413kee__n
keyway1943823keyway
kneepan1372623kneepan
lean46345243_le_an
leeward1135783leeward
leeways1354453leeways
legman949653legman
leman75622603_leman
mean65538093_me_an
median94117543median
merman10513863merman
mesian84315503mesian
messan83912063messan
ocean71212963oce_an
paean77222723pae_an
paesan85114093paesan
pean66147173_pe_an
pecan91919033_pecan
pechan13511543pechan
peen65938083pee__n
peewee11311963peewee
peewit111110903peewit
pekan111613973_pekan
penman10312323penman
pesewa1135543pesewa_
pesewas1236223pesewas
preman104117453preman
prewar114712583prewar
prewarn124410153prewarn
quean143612843que_an
rebegan1045953rebegan
redan66125013_redan
reearn6612143reearn
reedman1037723reedman
reloan6415693reloan
reman75730153_reman
renewal1038703renewal
replan83215823replan
reran57329103_reran
resawn9399953resawn
resewn9459813resew_n
rewax155713923_rewax
rewear93012003rewear
rewin85623963_rewin
rewon86920583_rewon
rowan85418733_rowan
seaman84015903seaman
seawans10379943seawans
seawant103613413seawant
seaway12309993seaway
sedan65620423_sedan
seedman1037373seedman
seen46943123see__n
seesaw935973seesaw
seitan62613233seitan
sewans95215903_sewans
sewar85421103_sewar
sewn76124333_sew_n
sextan13389643sextan
shewn115715703shew_n
skean94415623ske_an
spean74620513spe_an
stewpan1234193stewpan
swan76631313__swan
teen45938203tee__n
teleman959573teleman
teleran7510173teleran
teopan839353teopan
trepan82511673trepan
veejay1933703veejay
veena81912323veena_
veenas91410413veenas
vegan95114153_vegan
veteran1039353veteran
wan66761943___wan
wean75734353_we_an
ween75835463wee__n
weewee12310083weewee
yean75834583_ye_an
yeelin939343yeelin
yeoman1138823yeoman

Search took 6 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.376475242.0
2DLD Change Limit1127162445.39020912.1
3Display Results2442440.0763210.5
 (SQL Overall)1786912445.84230587.3
 
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.