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 “obelised” 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
obelised113617(None) 
obelise9310171obelise_
obelises1039101obelises
obelized2036331obelized
belied95022162_beli_ed
mobilised1445452mobilised
novelised1344982novelised
obelisk1345192obelis_k
obelisks1443442obelisks
obelism1138202obelis_m
obelisms1236392obelisms
obelize1838242obelize_
obelizes1937512obelizes
obliged1134982ob_liged
abolished1544273abolished
abscised1364133abscised
beelined11277713beelined
bekissed1543163_bekissed
belaced124112153_belaced
belated103520013_belated
belayed133610083_belayed
belched154011843_belched
belie75630383_beli_e_
belief115018603_beli_ef
belier84423563_beli_er
belies84631053_beli_es
believed14427923_believed
belike124616283_belike_
belive115415303_belive_
belled94626193_bel_led
bellied104314073_bellied
beloved13188393_beloved
belted94020633_bel_ted
bemired123410633_bemired
bemisted1368383_bemisted
bemixed19337053_bemixed
bemused1236713_bemused
berimed124912283_berimed
beslimed1335013_beslimed
betided114810203_betided
betise85616273_betise_
betises94816123_betises
blessed10319493_blessed
blissed10388373_b_lissed
bollixed1834483bollixed
braised104014803_braised
bruised10389503_bruised
bylined1335853_bylined
cheliped1635043cheliped
creolised1255203creolised
delimed11310723_delimed
delisted10310563_delisted
demised113613683_demised
devised123712563_devised
ebonised1136043ebonised
elegised10145923elegised
elided84814673__elided
focalised15156953focalised
globalised1443213globalised
idealised1145673idealised
idolised1045673idolised
itemised11105163itemised
lobeline1039963lobeline_
lobelines1138563lobelines
localised12167863localised
mobilise1248143mobilise_
mobilises1347513mobilises
mobilized2346753mobilized
monetised1246973monetised
moralised1239663moralised
nebulised1243733nebulised
novelise1137953novelise_
novelises1247373novelises
novelized2245313novelized
obeli73711933obeli___
obelia8329453obeli__a
obelias9279033obeli_as
obeliscal1351953obeliscal
obelising1256323obelising
obelus8348403obelus__
obese75212423obe__se_
obeyed1235823obe__yed
oblige937653ob_lige_
obligee1046863ob_ligee
obliger1035283ob_liger
obliges1037143ob_liges
obliqued2043353ob_liqued
obsessed1144273obsessed
obtained1136533obtained
outlined92512953outlined
outlived12269583outlived
overlived16248513overlived
overused1249443overused
oxalises1538503oxalises
oxidised1743413oxidised
ozonised1853893ozonised
peised94817683_pe_ised
poetised1138523poetised
precised133213413precised
premised133013193premised
prevised143611073prevised
realised92214533realised
relied74926233_reli_ed
relined85321933_relined
relished1239433_relished
relisted9312623_relisted
relived115114683_relived
remised103516843_remised
revised113815483_revised
seised74218123_se_ised
soberized2197043soberized
solecised1285873solecised
stylised12215893stylised
suberised1299033suberised
totalised1048073totalised
trellised1044653trellised
utilised956733utilised
vocalised15157393vocalised
vowelized2543473vowelized

Search took 7 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.420425454.8
2DLD Change Limit1461621196.44022696.0
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.90625874.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.