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

194 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
deploys133652(None) 
deploy1237581deploy_
decoys123911282de_coys
delays104014052de_lays
deplore1039482deplore
deplores1139532deplores
deployed1535912deployed
deployer1445632deployer
deployers1545062deployers
depots94716342dep_ots
diploes101111492diploes
employs1455522employs
peplos101211542peplo_s
ploys105816592__ploys
redeploys1552512redeploys
replays12399762replays
replots93412632replots
replows12329702replows
sepoys1138472sep_oys
tepoys1137542tep_oys
alloys94014563_alloys
beclogs1237073beclogs
belays114313853be_lays
bellboys1544523bellboys
bellows124313303bellows
belons84119413be_lons
belows114614183be_lows
byplays1743103byplays
cellos84517803cello_s
celoms10412123ce_loms
cloys104916943__cloys
coemploys1842763coemploys
coplots11511593coplots
deacons10310393deacons
dealers84118613dealers
deals65435343deal__s
debtors1038533debtors
decalogs1245633decalogs
decays124612913de_cays
declass1038733declass
declaws1336253declaws
decolors1187713decolors
decors94017773de_cors
decos85522123de_co_s
decoy115716313de_coy_
deejays1843433deejays
deeply1257013deepl_y_
defleas1147223defleas
defogs1156683de_fogs
defrays1436113defrays
deils65722863deil__s
dekkos1034103dekko_s
delay94820633de_lay_
deles65139253de_l_es
delfs94918673de_l_fs
delfts10439673de_lfts
delis64928543de_l_is
dellies83622213dellies
dells66630943de_l_ls
delly96023873de_lly_
delouse839833de_louse
dels56745473de_l__s
deltas74414823de_ltas
delts65731793de_l_ts
delves104917083de_lves
demobs11429483de_mobs
demons94917723de_mons
demos86022993de_mo_s
departs104310683departs
depends11348993depends
deperms1236603deperms
depicts12358463depicts
deplane10311413deplane
deplanes11311213deplanes
deplete103010423deplete
depletes112810643depletes
deplored1237233deplored
deplorer1136343deplorer
deplorers1245463deplorers
deploying1636153deploying
deplume1255063deplume
deplumes1334943deplumes
depolish1446943depolish
depone93616553dep_one
depones103717093depones
deport94922393dep_ort
deports105012883deports
depose94215763dep_ose
deposes103117213deposes
depot85727923dep_o_t
depress10239873depress
depths12428573dep_ths
deputes104911783deputes
deputy12426713deputy_
derays105514253de_rays
despots10319683despots
destroys1236693destroys
develops14145323develops
devious1138523devious
devons104512253de_vons
dewlaps1334663dewlaps
dewless1137473dewless
dewools1145593dewools
deys85027473de___ys
dialogs938103dialogs
diglots9299503diglots
diploe9810153diplo_e
diploic1247763diploic
diploid11310293diploid
diploids1247843diploids
diploma1295933diploma
diplomas1385993diplomas
diplont10311693diplont
diplonts1146473diplonts
diploses111110323diploses
diplosis11128413diplosis
dipoles101013753dipoles
dipsos95310053dipso_s
disemploys1852133disemploys
displays1446293displays
doblons1037043doblons
dollops10287963dollops
dolors75115313d_olors
doyleys14384923doyleys
drylots1143743drylots
duellos845763duello_s
duologs935363duologs
employ1346493employ_
employe1476363employe
employes1555943employes
enjoys1644603_enjoys
envoys1255143_envoys
ephods1238363_ephods
ephors11311403_ephors
epilogs1076583_epilogs
epos66723733_ep_o_s
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
helloes103717463helloes
hellos95321683hello_s
helos84928063he_lo_s
helots95217703he_lots
henleys1334843henleys
jealous1438093jealous
jellos134714283jello_s
leprosy1244223leprosy
leprous938843leprous
leptons91910433leptons
medleys13115333medleys
mellows123812233mellows
melons84117713me_lons
merlons93311273merlons
merlots92710123merlots
peploses1269473peploses
peplums13145503peplums
peplus10138343pepl_us
pepos96620083pep_o_s
plays106320773__plays
plods85719293__plods
plops95920333__plops
plots75025673__plots
plows105419903__plows
ploy96123603__ploy_
polys105718763__polys
redeploy1453173redeploy_
reemploys1653003reemploys
reflows13258983reflows
regloss8218023regloss
reglows11288843reglows
relays94316753re_lays
repays113813973rep_ays
replans92814943replans
replay113412923replay_
replies94521043replies
replot83818593replo_t
replow114210343replo_w
reply104015853repl_y_
repolls939053repolls
repos74725793rep_o_s
repots85621003rep_ots
repros84216003repro_s
sepalous1047523sepalous
sepoy10314303sep_oy_
splays114910873_splays
teapoys1235963teapoys
teflons1036543teflons
tellys9348843te_llys
telos55424523te_lo_s
tepoy10312163tep_oy_
weblogs1334223weblogs
yellows13329603yellows
zealots1636763zealots
zealous1637813zealous

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271945.89022755.0
3Display Results1941940.0633079.4
 (SQL Overall)1786911946.34628158.1
 
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.