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

79 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
demolish144783(None) 
depolish1446941depolish
delish105215612de__lish
demolished1794522demolished
demolisher1693642demolisher
demolishes1684902demolishes
demonise11411932demonise
demonism1359452demonism
demonist11413462demonist
demotist11311842demotist
devilish1546372devilish
lemonish1347312lemonish
repolish1347932repolish
abolish12311503_abolish
admonish1446033admonish
aerolith1149833aerolith
ceorlish1345383ceorlish
coolish12312523_coolish
dampish1567663dam_pish
deafish1438533de_afish
dealfish1545503dealfish
delis64928543de__lis_
delist74625053de__list
demise94618323dem__ise
demobs11429483demo_bs_
demoing11311753demo_ing
demolishers1792583demolishers
demolishing1843883demolishing
demoness1138053demoness
demoniac1346873demoniac
demonian1147713demonian
demonic12311223demoni_c
demonised1348233demonised
demonises12311093demonises
demonisms1448053demonisms
demonists1248703demonists
demonize20311533demonize
demons94917723demo_ns_
demos86022993demo__s_
demoses103815823demoses_
demotes104717673demotes_
demotic12412333demoti_c
demotics1338753demotics
demoting12311423demoting
demotion1169073demotion
demotists1247323demotists
depolished17103613depolished
depolishes1694123depolishes
dervish1436983de_rvish
devilfish1942323devilfish
diminish14127523diminish
dollish11610093d_ollish
doltish11118733d__oltish
dovish1338103d__ovish
dronish1138913d_ronish
dullish1148743d_ullish
dumpish15116113dum_pish
embolism1446793_embolism
english1137953_english
eolith93013903_e_olith
feeblish1644163feeblish
foolish1339613_foolish
hellish13310723he_llish
memorise121411433memorise
modish123813543__modish
monish114217593__monish
mopish134311593__mopish
mulish11311903__mulish
neolith1068783ne_olith
nerolis71012773nerolis_
pemoline12310273pemoline
polish114916723__polish
premonish1646803premonish
regolith1247543regolith
relish93916953re__lish
remolds10299703remolds_
semolina1047493semolina
unmodish1443913unmodish
xenolith1845653xenolith

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.203880251.2
2DLD Change Limit146162798.22017781.3
3Display Results79790.0302633.3
 (SQL Overall)178691798.45321139.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.