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

107 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
obiisms113567(None) 
obiism1036361obiism_
hoboisms1545562hoboisms
mobbisms1643772mobbisms
obelisms1236392obelisms
oboists937902oboists
ogrisms1036442ogrisms
zombiisms2442292zombiisms
abioses9311493abioses
abiosis939373abiosis
ableisms1245413ableisms
abysms13565653ab_ysms
ageisms1056603ageisms
agisms9399393_agisms
albinisms1395773albinisms
animisms12328393animisms
autisms94311553autisms
biases84618433_biases
birses84717733_birses
bises75435623_b_ises
bisks115416803_b_isks
bliss75616913_blis_s
bogyisms1643823bogyisms
bossisms1244703bossisms
brims94721623_bri_ms
brises84927613_brises
brisks124611403_brisks
briss75824273_bris_s
chiasms14357523chiasms
chrisms1499143chrisms
civisms1436073civisms
cosmisms1446223cosmisms
cubisms13306883cubisms
deisms94411043_deisms
dodoisms1244523dodoisms
egoisms1065953egoisms
elitisms1048193elitisms
eonisms92811043eonisms
favisms1535443favisms
fogyisms1743283fogyisms
hoboism1446623hoboism_
holisms123811113holisms
ibises83610543ib_ises
iodisms10308483iodisms
isms66213473___isms
jisms14458003__jisms
laicisms1247123laicisms
lobbyisms1842413lobbyisms
locoisms1256143locoisms
lookisms1444793lookisms
lyrisms1235653lyrisms
miasms1097383_miasms
mobbism1535053mobbism_
mobilises1347513mobilises
momisms10308223momisms
monisms113512803monisms
mutisms11338453mutisms
nanisms938833nanisms
nomisms11268743nomisms
nudisms10305853nudisms
obeahisms1642853obeahisms
obelises1039103obelises
obelisks1443443obelisks
obelism1138203obelism_
obias76116863ob_i_as
obis66226843ob_i__s
obits74617553ob_i_ts
oblasts947303oblasts
obliges1037143obliges
oboist8312683obois_t
obsess845943obses_s
obtests9136233obtests
obvious1244823obvious
odists749853o_dists
odiums9337943o_diums
ogreisms1144113ogreisms
ogrism937913ogrism_
onanisms1048063onanisms
opiumisms1542633opiumisms
opiums10307073o_piums
optimisms1555223optimisms
oralisms10610973oralisms
orgasms1054293orgasms
orphisms1545993orphisms
orrises71312233orrises
osmiums1134143osmiums
otitises839163otitises
oxidises1644833oxidises
oxims14107643o_xi_ms
papisms13238543papisms
porisms113713453porisms
prisms104915503_prisms
purisms114110833purisms
racisms112310813racisms
robotisms1375123robotisms
sadisms10359113sadisms
schisms1437173schisms
seisms84912143_seisms
sexisms16226223sexisms
snobbisms1542713snobbisms
sophisms1546653sophisms
theisms1237763theisms
tourisms1037613tourisms
truisms9106823truisms
verisms123011253verisms
vibists1256483vibists
zombiism2342433zombiism_

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.406440125.6
2DLD Change Limit1340271076.11021935.7
3Display Results1071070.0462326.1
 (SQL Overall)1786911076.56227231.2
 
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.