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

119 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
deploying163615(None) 
deploring1337851deploring
decoying15208762de_coying
delaying133210972de_laying
deplaning1338052deplaning
depleting1378192depleting
depluming1544712depluming
deponing121211212dep_oning
deposing12129772dep_osing
employing1765342employing
ploying132811572__ploying
redeploying1842702redeploying
replaying15259602replaying
replowing1537412replowing
replying14269402repl_ying
alloying12339143_alloying
applying1634653appl_ying
belaying143110603be_laying
bellowing1547193bellowing
bellying14359073be_llying
belying133612443be_l_ying
cloying133511753__cloying
coemploying2152413coemploying
dallying13368493d_allying
deaconing1337193deaconing
dealing94323233deal__ing
deboning12109153de_boning
decaying15239453de_caying
declaring1339573declaring
declawing1636213declawing
declining13129353declining
decoding132410053de_coding
decoloring1486313decoloring
decrying15237413de_crying
deejaying2142753deejaying
deflating142610713deflating
defleaing1444743defleaing
defraying1735853defraying
defying15328823de__fying
deglazing2135133deglazing
deifying1637633de_ifying
delating103119603de_lating
deleing93313953de_l_eing
deleting103314423de_leting
deliming12310373de_liming
delousing1136303de_lousing
deluding1137683de_luding
deluging1137123de_luging
delving123711573de_l_ving
demoing11311753de_mo_ing
demoting12311423de_moting
denoting10311753de_noting
denying123711293de__nying
departing1349513departing
depending14208783depending
depeopling1642643depeopling
deperming1537113deperming
depicting1537813depicting
depilating1439183depilating
deploringly1852273deploringly
deploy1237583deploy___
deployed1535913deploy_ed
deployer1445633deploy_er
deployers1545063deployers
deployment1855523deployment
deploys1336523deploy__s
deporting1369593deporting
depraving1635973depraving
depriving1636403depriving
deputing12238793dep_uting
descrying1635103descrying
destroying1564903destroying
detoxing1736313de_toxing
developing1743673developing
devolving1733983devolving
devoting1338823de_voting
dewooling1444323dewooling
dialoging1246313dialoging
diplomaing1643573diplomaing
disemploying2152483disemploying
displaying1746313displaying
disploding1575873disploding
dolloping1344993dolloping
dollying13407413d_ollying
duplexing2042793duplexing
eloping103512833_e_loping
enjoying1935003_enjoying
epoxying2133033_epoxying
exploding2044933exploding
exploring1945543exploring
fellowing1655923fellowing
helloing12159123hello_ing
imploding1545213imploding
imploring1445573imploring
implying1635533impl_ying
jellying19306173je_llying
mellowing1545893mellowing
playing133816093__playing
plowing133111723__plowing
plying124312083__pl_ying
reemploying1952833reemploying
reflowing1636523reflowing
reflying15268173refl_ying
reglowing1436173reglowing
relaying122515153re_laying
relying112914613re_l_ying
repaying142712393rep_aying
replacing142210163replacing
replating122217403replating
replevying1953273replevying
replotting1357043replotting
repolling122110203repolling
reposing111213803rep_osing
reprobing1438073reprobing
reproving1538413reproving
splaying14219303_splaying
tepefying1843233tepefying
uncloying1555813uncloying
yellowing1655073yellowing

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 Filter1786911486410.483369960.7
2DLD Change Limit1486411197.33020278.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.85922737.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.