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 “deployer” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
deployer144563(None) 
deplorer1136341deplorer
deployed1535911deployed
deployers1545061deployers
decoyer13348682de_coyer
deflower15126072deflower
delayer113010532de_layer
depleter11298862depleter
deplore1039482deplore_
deplored1237232deplored
deplorers1245462deplorers
deplores1139532deplores
deploy1237582deploy__
deploys1336522deploy_s
deposer104011842dep_oser
employer1564712employer
beflower16166273beflower
belayer12339503be_layer
bellower13159063bellower
caloyer1238143_caloyer
dealer74122143deal__er
deboner103110483de_boner
decayer13339353de_cayer
declarer1148063declarer
decliner113710843decliner
decoder113712293de_coder
decoyed14358333de_coyed
decoyers14287713de_coyers
deflater123211603deflater
deflowers16145643deflowers
defrayer1534933defrayer
delayed123310763de_layed
delayers12268663de_layers
deliver113312243de_liver
delouser936363de_louser
deluder9168333de_luder
delver104913493de_l_ver
depicter1356853depicter
deplane10311413deplane_
deplaned1238663deplaned
deplanes11311213deplanes
deplete103010423deplete_
depleted12258723depleted
depleters12327543depleters
depletes112810643depletes
deploying1636153deploying
deployment1855523deployment
deplume1255063deplume_
deplumed1434083deplumed
deplumes1334943deplumes
depone93616553dep_one_
deponed113712873dep_oned
depones103717093dep_ones
deporter1169393deporter
depose94215763dep_ose_
deposed113412023dep_osed
deposers11359243dep_osers
deposes103117213dep_oses
depraver1435413depraver
depriver1446293depriver
destroyer1344553destroyer
developer15134243developer
dialoger1056083dialoger
diplexer1844213diplexer
diploe9810153diplo_e_
diploes101111493diplo_es
diploses111110323diploses
displayer1545833displayer
duplexer1842903duplexer
eloper85414153_e_loper
employe1476363employe_
employed1654953employed
employee1555203employee
employers1644123employers
employes1555943employes
enjoyer1744383_enjoyer
exploder1844843exploder
explorer1744713explorer
geologer1044483geologer
implorer12125103implorer
mellower13167403mellower
peploses1269473peploses
player115215213__player
plover115312613__plover
plower114315063__plower
ployed124310563__ployed
plyer106214333__pl_yer
redeployed1742623redeployed
reflower14126843reflower
replacer12279743replacer
replayed14248633replayed
replier94214973repl_ier
replowed14127573replowed
reposer93715333rep_oser
repower12329883rep_ower
reprover13229203reprover
yellower14186213yellower

Search took 8 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.406440125.6
2DLD Change Limit146162976.57622226.6
3Display Results97970.0332939.4
 (SQL Overall)178691977.01525472.7
 
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.