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

65 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
depolish144694(None) 
demolish1447831demolish
repolish1347931repolish
delish105215612de__lish
depolished17103612depolished
depolishes1694122depolishes
devilish1546372devilish
polish114916722__polish
abolish12311503_abolish
aerolith1149833aerolith
ceorlish1345383ceorlish
coolish12312523_coolish
deafish1438533de_afish
dealfish1545503dealfish
delis64928543de__lis_
delist74625053de__list
demolished1794523demolished
demolisher1693643demolisher
demolishes1684903demolishes
demonise11411933demonise
demonism1359453demonism
demonist11413473demonist
demotist11311843demotist
deploys1336523deploys_
depolishing1843503depolishing
depones103717093depones_
deponing121211213deponing
deports105012883deports_
depose94215763depo__se
deposes103117213deposes_
deposing12129773deposing
deposit10313003deposi_t
deposits1138843deposits
depots94716343depo_ts_
dervish1436983de_rvish
despoils1145623despoils_
despotism1444043despotism
devilfish1942323devilfish
dipoles101013753dipoles_
dollish11610093d_ollish
doltish11118733d__oltish
dovish1338103d__ovish
dronish1138913d_ronish
dullish1148743d_ullish
english1137953_english
eolith93013903_e_olith
feeblish1644163feeblish
foolish1339613_foolish
hellish13310723he_llish
lemonish1347323lemonish
neolith1068783ne_olith
nepotism1246483nepotism
nepotist1059233nepotist
nerolis71012773nerolis_
palish114718273__palish
polis74731163__polis_
popish133812113__popish
regolith1247543regolith
relish93916953re__lish
repolished16114493repolished
repolishes15105103repolishes
repolls939053repolls_
republish1643823republish
vaporish16246733vaporish
xenolith1845653xenolith

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.436409841.7
2DLD Change Limit146162656.54622328.4
3Display Results65650.0302166.7
 (SQL Overall)178691657.01225483.6
 
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.