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

196 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
deewans1130690(None) 
deewan10267551deewan_
dewans105215141d_ewans
deans66131392d_e_ans
dedans85915072d_edans
deejays1843432deejays
deepens10307812deepens
demeans1039722demeans
desmans1039002desmans
dewan95718042d_ewan_
dewars105117072d_ewars
diwans105110372d_iwans
leeways1354452leeways
seawans10379942seawans
sewans95215902_sewans
ajowans1734003ajowans
beans75734693_be_ans
bedpans1237173bedpans
bemeans1148743bemeans
bemoans1138253bemoans
cleans85817053cle_ans
daemons10269233daemons
damans94715983d_amans
dans56748153d___ans
dawns95916593d_aw_ns
deacons10310393deacons
deadens93410693deadens
deadpans12205173deadpans
deads75726913d_e_ads
deafens11317253deafens
deals65435343d_e_als
dean56039483d_e_an_
dears65736883d_e_ars
debags104211063d_ebags
debars94218043d_ebars
debeaks1436103debeaks
decafs124010883d_ecafs
decals93717713d_ecals
decane93818873d_ecane
decanes103118913d_ecanes
decant93524223d_ecant
decants103514443d_ecants
decays124612913d_ecays
decerns10119053decerns
declass1038733declass
declaws1336253declaws
deeding103315123deeding
deeds75423763dee__ds
deejay1734523deeja_y
deeming113913123deeming
deems85421773dee__ms
deepen9339193deepen_
deeps84921773dee__ps
deers64930523dee__rs
dees56356633dee___s
deets65330243dee__ts
defang1137753d_efang
defangs1235363d_efangs
defats105114553d_efats
defeats113511233defeats
defiant11311923defiant
defoams1336193defoams
defrags1236193defrags
defrays1436113defrays
degas75119163d_ega_s
dehorns11428363dehorns
deigns8389983d_eigns
delays104014053d_elays
deleads9379703deleads
deltas74414823delta_s
demand104314253d_emand
demands114311413d_emands
demean9510563demean_
demetons1137623demetons
demons94917723d_emons
denars74621433d_enars
denials84114133denials
dens55945073d_e__ns
dentals83915393dentals
dentins83419223dentins
deodand1035713deodand
deodands1144603deodands
deodars937623deodars
deplane10311413deplane
deplanes11311213deplanes
derats74625063d_erats
derays105514253d_erays
dermas94116813derma_s
desand84812633d_esand
desands94810163d_esands
descant104315593descant
descants112910143descants
designs9328313designs
desman9311693desman_
destains9311813destains
detains83716093detains
detrains9411763detrains
devas96218883d_eva_s
deveins1138813deveins
deviant11311313deviant
deviants1236733deviants
devons104512253d_evons
dewar95817733d_ewa_r
dewax165510853d_ewa_x
dewaxes18297843d_ewaxes
dewing114115703d_ewing
dewlaps1334663dewlaps
dews86230603d_ew__s
dextrans1695983dextrans
dioxans1555313dioxans
divans104612393d_ivans
diwan95712553d_iwan_
dolmans10479683dolmans
downs94918573d_ow_ns
dreads84115023dre_ads
dreams94513983dre_ams
drears74614253dre_ars
drowns105612333drow_ns
duennas834143duennas
durians839573durians
edemas9310503edema_s
edgeways1642583edgeways
elans55527753__elans
freeways1744723freeways
geegaws1242343geegaws
germans1079473germans
gleans75014743gle_ans
gowans105512293_gowans
heehaws1643343heehaws
hetmans12187593hetmans
jawans1657843_jawans
jeans126022113_je_ans
jetways2094053jetways
keens95721183kee__ns
keyways2043373keyways
kneepans1462733kneepans
leans55536253_le_ans
leeward1135783leeward
leewards1244983leewards
leeway1255883leewa_y
lemans85316393_lemans
means75831233_me_ans
medians103214213medians
messans92710463messans
oceans81211003oce_ans
paeans85118263pae_ans
paesans93312693paesans
peans75437643_pe_ans
pecans101515833_pecans
pechans14810503pechans
peens76428193pee__ns
peewees1236803peewees
peewits12105873peewits
pekans121710553_pekans
pesewas1236223pesewa_s
prewarns13456943prewarns
queans153110753que_ans
redans75421023_redans
reearns749103reearns
reloans7313133reloans
remans84823003_remans
renewals1137273renewals
replans92814943replans
rewan85623663_rewan_
rewears102911043rewears
rewins95020823_rewins
rowans95715343_rowans
seawan94111223seawan_
seawant103613413seawant
seawants11337973seawants
seaways13307513seaways
sedans74816093_sedans
seesaws1034703seesaws
seitans73312303seitans
sewan85921293_sewan_
sewars94018633_sewars
sextans14349263sextans
skeans104512913ske_ans
sowans94215893_sowans
speans85417143spe_ans
stewpans1343713stewpans
swans84625013__swans
teens56227483tee__ns
telerans859473telerans
teopans939203teopans
trepans92311593trepans
veejays2042313veejays
veenas91410413veena_s
vegans103910853_vegans
veterans1148853veterans
wans76452273___wans
weans85326743_we_ans
weens85224053wee__ns
weewees1336563weewees
yeans86624883_ye_ans
yeelins1038813yeelins

Search took 9 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 Filter1786911340270.453394461.4
2DLD Change Limit1340271967.72017361.0
3Display Results1961960.0603266.7
 (SQL Overall)1786911968.23321704.2
 
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.