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

56 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
obelisks144344(None) 
obelises1039101obelises
obelisk1345191obelisk_
obelisms1236391obelisms
obelias9279032obeli_as
obelise9310172obelis_e
obelised1136172obelised
obelism1138202obelis_m
obelizes1937512obelizes
odalisks1363502odalisks
abelias93213563abeli_as
abelmosks1761073abelmosks
ableisms1245413ableisms
ableists1036543ableists
bekiss1236373_bekis_s
beliefs12448583_beliefs
beliers94617383_beliers
belies84631053_beli_es
belike124616283_beli_ke
bemists113410703_bemists
betises94816123_betises
beyliks1634853_beyli_ks
bisks115416803_b__isks
blinks124613573_b_links
bliss75616913_b_lis_s
bobolinks1742493bobolinks
brisks124611403_b_risks
delists84414173_delists
duelists966003duelists
libelists1146953libelists
lobelias1047203lobeli_as
lobelines1138563lobelines
mobilises1347513mobilises
modelists1246473modelists
nobeliums1343893nobeliums
novelises1247373novelises
novelists1245933novelists
obeahisms1642853obeahisms
obeli73711933obeli___
obelia8329453obeli__a
obeliscal1351953obeliscal
obelising1256323obelising
obelize1838243obeli_ze
obelized2036333obelized
obelus8348403obel__us
obiisms1135673ob_iisms
oblasts947303ob_lasts
obliges1037143ob_liges
oboists937903ob_oists
oculists1037133oculists
odalisk1265373odalisk_
oralisms10610973oralisms
oralists8611803oralists
oxalises1538503oxalises
relinks114510223_relinks
relists73817053_relists

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 Limit146162567.15620425.1
3Display Results56560.0301866.7
 (SQL Overall)178691567.62223444.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.