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

137 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
deployed153590(None) 
deplored1237221deplored
deployer1445631deployer
decoyed14358332de_coyed
delayed123310762de_layed
deplaned1238652deplaned
depleted12258712depleted
deplore1039482deplore_
deplorer1136342deplorer
deplores1139532deplores
deploy1237582deploy__
deployers1545062deployers
deploys1336522deploy_s
deplumed1434072deplumed
deponed113712872dep_oned
deposed113412022dep_osed
employed1654942employed
ployed124310562__ployed
redeployed1742622redeployed
replayed14248622replayed
replowed14127562replowed
alloyed11158033_alloyed
belayed133610083be_layed
bellowed14158603bellowed
beloved13188393be_loved
cloyed125111563__cloyed
coemployed2042683coemployed
deaconed1237493deaconed
dealated103213603dealated
deboned113411633de_boned
decayed14309333de_cayed
declared1248743declared
declawed1545923declawed
declined123910883declined
decoded123212383de_coded
decolored1345663decolored
decoyer13348683de_coyer
deejayed2042443deejayed
deflated133412303deflated
defleaed1344943defleaed
deflexed2043873deflexed
deflower15126073deflower
defrayed1635403defrayed
deglazed2034953deglazed
delated93722873de_lated
delayer113010533de_layer
deled75326543de_l__ed
deleted93314903de_leted
delimed11310723de_limed
deloused1036973de_loused
deluded10158763de_luded
deluged10167413de_luged
delved114112753de_l_ved
demoded123611123de_moded
demoed103713443de_mo_ed
demoted114313543de_moted
denoted93512763de_noted
departed1238823departed
depended1337983depended
depeopled1543223depeopled
depermed1436453depermed
depicted1437743depicted
depilated1339653depilated
deplane10311413deplane_
deplanes11311213deplanes
deplete103010413deplete_
depleter11298853depleter
depletes112810633depletes
deplorers1245463deplorers
deploying1636153deploying
deployment1855523deployment
deplume1255063deplume_
deplumes1334943deplumes
depone93616553dep_one_
depones103717093dep_ones
deported1249703deported
depose94215763dep_ose_
deposer104011843dep_oser
deposes103117213dep_oses
depraved1535543depraved
deprived1546463deprived
deputed114610173dep_uted
destroyed1445083destroyed
detoxed1636103de_toxed
developed16124313developed
devolved16325513devolved
devoted124111093de_voted
dewooled1333833dewooled
dialoged1146693dialoged
diploe9810153diplo_e_
diploes101111493diplo_es
diploid11310293diplo_id
diplomaed1573713diplomaed
diplopod1453883diplopod
diploses111110323diploses
disemployed2062563disemployed
displayed1645883displayed
disploded1446543disploded
dolloped1234983dolloped
duplexed1943133duplexed
eloped95914143_e_loped
employe1476363employe_
employee1555203employee
employer1564713employer
employes1555943employes
enjoyed1834523_enjoyed
epoxyed2032293_epoxyed
exploded1944743exploded
explored1845073explored
fellowed15136833fellowed
helloed113512423hello_ed
imploded14145073imploded
implored13135373implored
mellowed14166923mellowed
peploses1269463peploses
peplumed1543033peplumed
played124815033__played
plowed124213203__plowed
reemployed1843173reemployed
reflowed15126903reflowed
reglowed13125853reglowed
relayed113212753re_layed
replaced133211393replaced
replated112817513replated
repled93319773repl__ed
replied103914443repl_ied
replotted1235823replotted
repolled11359623repolled
reposed103616273rep_osed
reprobed13228743reprobed
reproved14199473reproved
splayed13357813_splayed
uncloyed1487343uncloyed
unemployed1843073unemployed
unplayed1437263unplayed
unplowed1436353unplowed
yellowed15185743yellowed

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621378.73316736.7
3Display Results1371370.0462978.3
 (SQL Overall)1786911378.93519999.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.