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

292 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
deploy123758(None) 
deploys1336521deploys
decoy115716312de_coy
deeply1257012deepl_y
delay94820632de_lay
delly96023872de_lly
deplore1039482deplore
deployed1535912deployed
deployer1445632deployer
depot85727922dep_ot
deputy12426712deputy
diploe9810152diploe
employ1346492employ
peplos101211542peplos
ploy96123602__ploy
redeploy1453172redeploy
replay113412922replay
replot83818592replot
replow114210342replow
reply104015852repl_y
sepoy10314302sep_oy
tepoy10312162tep_oy
adeptly1344183adeptly
alloy85519973_alloy
amply125012913ampl_y
apply125111393appl_y
beclog1136863beclog
belay105021523be_lay
bellboy1445123bellboy
bellow114213353bellow
belly104625493be_lly
belon73924113be_lon
below104617193be_low
byplay1634193byplay
cello74919583cello_
cellos84517803cellos
celom9515683ce_lom
cloy96623833__cloy
coemploy1743323coemploy
coplot10518273coplot
daily95922333dail_y
dally95324743d_ally
damply14337893dampl_y
deacon9510423deacon
deadly113811473deadly
deafly13389123deafly
deal56347413deal__
dealer74122143dealer
deals65435343deal_s
dealt65234283deal_t
dearly104615323dearly
deary95826843de_ary
deathy134210233deathy
debtor938333debtor
decalog1136003decalog
decay114718483de_cay
declaw1266703declaw
deco76125973de_co_
decolor1087033decolor
decor84717573de_cor
decos85522123de_cos
decoys123911283de_coys
decry115514353de_cry
decury1277963decury
deedy104315893de_edy
deejay1734523deejay
deflea1037443deflea
defog1048523de_fog
defray1337643defray
deftly1336533deftly
defy114921263de__fy
deify124112763de_ify
deil56231623deil__
deils65722863deil_s
deity94316773de_ity
dekko936393dekko_
dekkos1034103dekkos
del46752753de_l__
delays104014053de_lays
dele56843083de_l_e
deled75326543de_led
deles65139253de_les
delf85436573de_l_f
delfs94918673de_lfs
delft95623323de_lft
deli55631293de_l_i
delis64928543de_lis
dell56938203de_l_l
dells66630943de_lls
dels56745473de_l_s
delt57855273de_l_t
delta66117773de_lta
delts65731793de_lts
delve96018263de_lve
demo77427553de_mo_
demob104913503de_mob
demon86520313de_mon
demos86022993de_mos
demy105422853de__my
denary105316863denary
deny86027123de__ny
deoxy1648883de_oxy
depart94720563depart
depend103510923depend
deperm1139363deperm
depict113514793depict
deplane10311413deplane
deplete103010423deplete
deplored1237233deplored
deplorer1136343deplorer
deplores1139533deplores
deployers1545063deployers
deploying1636153deploying
deplume1255063deplume
depone93616553depone
deport94922393deport
depose94215763depose
depots94716343depots
depth114311853dep_th
depths12428573depths
depute94512303depute
deray95024183de_ray
derby114715343de_rby
derry94721373de_rry
descry1256183descry
desoxy1744623desoxy
despot93413293despot
destroy1138153destroy
detox13310953de_tox
develop13145033develop
devilry1433973devilry
devon95113683de_von
dewily1338343dewily
dewlap1264843dewlap
dewool1047403dewool
dewy115419023de__wy
dexy156118553de__xy
dey77243373de___y
dhooly13457143dhooly
dialog837973dialog
diglot83014333diglot
dilly94923783d_illy
dimly114913483diml_y
dimply14339743dimpl_y
diplex16408053diplex
diploes101111493diploes
diploic1247763diploic
diploid11310293diploid
diploidy1544733diploidy
diploma1295933diploma
diplont10311693diplont
dipody1336363dipody
dipole91112853dipole
dippy135111543dip_py
dipso85111553dipso_
dipsos95310053dipsos
disemploy1752563disemploy
display1336663display
doblon938013doblon
doily95321033doil_y
dollop9259363dollop
dolly96125203d_olly
dolor67617963d_olor
dooly94821803dool_y
dopey116020353dop_ey
dopily123510463dopily
dopy106224153dop__y
doyley13487283doyley
doyly124514013doyl_y
drily95816523dril_y
drolly105411673drolly
drooly104911073drooly
drylot1037403drylot
dryly12538453dryl_y
dually103210063dually
duello756783duello_
duellos845763duellos
dully94921633d_ully
duly85323033d_ul_y
duolog835803duolog
duopoly1343683duopoly
dupery12378743dupery
duple85315863dupl_e
duplex16386973duplex
eely77725213_eel_y
elmy95616793_e_lmy
employe1476363employe
employs1455523employs
enjoy1545963_enjoy
envoy1156723_envoy
ephod1139123_ephod
ephor10310013_ephor
epilog976463_epilog
epos66723733_ep_os
epoxy17465773_epoxy
eulogy1035633_eulogy
fealty122910223fealty
felloe93513923felloe
fellow123712743fellow
felly114922803fe_lly
felon84619293fe_lon
felony123710323fe_lony
ferly115517353ferl_y
feyly14429513feyl_y
geology12257323geology
haply135915063hapl_y
hello86522983hello_
hellos95321683hellos
helo75332853he_lo_
helos84928063he_los
helot85332683he_lot
henley1237483henley
hiply134113613hipl_y
ideally1137793ideally
idealogy1342943idealogy
ideology1345653ideology
imply124911843impl_y
jello126716273jello_
jellos134714283jellos
jelly154218253je_lly
kelly124617023ke_lly
kelpy145110683ke_lpy
leally94012613leally
lealty92910603lealty
leprosy1244223leprosy
lepton82510803lepton
mealy104422183meal_y
medley1298333medley
mellow114112223mellow
melody1237203me_lody
melon73922083me_lon
melty104918363me_lty
merlon83012353merlon
merlot83217603merlot
nelly84618813ne_lly
neology11238293neology
newly114610203newl_y
pelon74423213pe_lon
pepla9312863pepl_a
peplum12156823peplum
peplus10138343peplus
pepo87622153pep_o_
pepos96620083pep_os
peppy114310363pep_py
play95928983__play
plod76723273__plod
plop86625743__plop
plot66141233__plot
plow95923233__plow
ploys105816593__ploys
ply86323553__pl_y
poly96235153__poly
really93315613really
realty92713693realty
redeploys1552513redeploys
redly94217203redl_y
reemploy1543343reemploy
reflow12379653reflow
refly113914563refl_y
reglow10339403reglow
relay84424673re_lay
rely75428953re_l_y
repay104818453rep_ay
replan83215823replan
replays12399763replays
repled93319783repled
replevy1533473replevy
replots93412633replots
replows12329703replows
repo66027543rep_o_
repoll8410793repoll
repos74725793rep_os
repot75132623rep_ot
repro75315913repro_
repros84216003repros
seely84522633seel_y
sepoys1138473sep_oys
splay105816043_splay
teapoy1138113teapoy
teflon937453teflon
telly84920823te_lly
teloi54217383te_loi
telos55424523te_los
tepefy1434803tepefy
tepoys1137543tep_oys
vealy115817773veal_y
weblog1234223weblog
welly114620013we_lly
wetly114511713wetl_y
yellow12429883yellow
yellowy16255693yellowy
zealot15313473zealot

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.403443402.0
2DLD Change Limit1127162925.95618924.8
3Display Results2922920.0933139.8
 (SQL Overall)1786912926.45227695.4
 
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.