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

84 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
obelisk134519(None) 
obelise9310171obelise
obelisks1443441obelisks
obelism1138201obelism
obeli73711932obeli__
obelia8329452obeli_a
obelias9279032obelias
obelised1136172obelised
obelises1039102obelises
obelisms1236392obelisms
obelize1838242obelize
obelus8348402obelus_
odalisk1265372odalisk
abeles84719393abeles_
abelia83114403abeli_a
abelian92810643abelian
abelias93213563abelias
abelmosk1641203abelmosk
ableism1136823ableism
ableist9311773ableist
abolish12311503abolish
bekiss1236373_bekiss
belie75630383_beli_e
belied95022163_belied
belief115018603_belief
belier84423563_belier
belies84631053_belies
belike124616283_belike
belive115415303_belive
bells76432163_bells_
bels66142493_bel_s_
belts75931163_belts_
bemist105216963_bemist
betise85616273_betise
beylik1545883_beyli_k
beyliks1634853_beyliks
bisk106523353_b__isk
blink115720143_b_link
bliss75616913_b_liss
bobolink1644493bobolink
brisk115615983_b_risk
delis64928543_delis_
delish105215613_delish
delist74625053_delist
duelist8511413duelist
libelist10310823libelist
lobelia947213lobeli_a
lobelias1047203lobelias
lobeline1039963lobeline
mobilise1248143mobilise
modelist11310503modelist
nobelium1245713nobelium
novelise1137953novelise
novelist1149453novelist
obeahism1542873obeahism
obeahs1135863obeahs_
obeliscal1351953obeliscal
obelising1256323obelising
obelized2036333obelized
obelizes1937513obelizes
obes66036833obe__s_
obese75212423obe__se
obesity1275653obesity
obeying1336543obeying
obeys107010643obe_ys_
obiism1036363ob_iism
obis66226843ob__is_
oblast8613663ob_last
oblige937653ob_lige
oboist8312683ob_oist
oboles83815833oboles_
oboli73712873oboli__
obols73715863obol_s_
obolus8378813obolus_
oculist9310883oculist
odalisks1363503odalisks
oralism9513763oralism
oralist7619633oralist
owlish1238703o_wlish
oxalis1339223oxalis_
relink104415923_relink
relish93916953_relish
relist64628413_relist
yokelish1843983yokelish

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 Filter1786911340270.403443402.0
2DLD Change Limit134027845.97022450.1
3Display Results84840.0302800.0
 (SQL Overall)178691846.40327907.4
 
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.