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

41 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
ischium144424(None) 
ischia1136392ischi_a
ischial1246422ischial
schism1338172_schism
aecium10410423aec_ium
ascidium1344813ascidium
brachium1766113brachium
chirm125317063__chirm
chum116318003__ch_um
ilium74614183i__lium
inching134414323inching
indium939503i_ndium
ionium8610923i_onium
iridium1046303iridium
isocheim1543333isocheim
isochime15113843isochime
isthmus1243263isthmus
itchier12247673itchier
itchily1574493itchily
itching134011683itching
lithium1245823lithium
mischief1846423mischief
osculum1143833osculum
osmium1036573os_mium
ostium8310133os_tium
schisms1437173_schisms
schist11312653_schist
schizo20115993_schizo
schizy23115043_schizy
schlub1355003_schlub
schlump1643263_schlump
scholium1545643_scholium
schuit1139563_schuit
schul102510413_sch_ul
scrim95419743_scri_m
scrum95418203_sc_rum
scum85924523_sc__um
scutum1036373_scutum
shim95827863_s_hi_m
sodium92111453_sodium
tachism1478873tachism

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.390458182.1
2DLD Change Limit134027416.43620824.6
3Display Results41410.0162562.5
 (SQL Overall)178691416.84226116.8
 
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.