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

104 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
locoism115679(None) 
locoisms1256141locoisms
dodoism1135892dodoism
hoboism1446622hoboism
laconism1248042laconism
localism121310012localism
locoes85516582locoes_
locoing102810972locoing
locos75822602loco_s_
lookism1335912lookism
blockish19115793blockish
boccis123911133boccis_
bogyism1545213bogyism
bossism1136063bossism
clonism1138983clo_nism
cockish1838503cockish
cocoas104915743cocoas_
cocos95624693coco_s_
cocoyam1644893cocoyam
colorism122112433colorism
cosmism1337013cosmism
dodoisms1244523dodoisms
echoism1447363echoism
egoism977473_egoism
eonism83213533eo_nism
fogyism1643943fogyism
heroism12311013heroism
hoboisms1545563hoboisms
holism113713753ho_lism
hylozoism2652373hylozoism
iodism93611133io_dism
jocose1537103joco_se
laconisms1347013laconisms
laicism1138243laicism
leftism12226093leftism
lichis115212593lichis_
lobbyism1742813lobbyism
lobos75921843lobo_s_
localise101511853localise
localisms13148733localisms
localist101613963localist
locals83714503locals_
lochia1158313lochi_a
lochial1257083lochial
lochs106715513loc_hs_
loci66126283loc_i__
locking143718153locking
lockram1544913lockram
locks115126923loc_ks_
loco67030743loco___
locoed94312193loco_ed
locum94812173loc__um
locums10478303locums_
locus74819993loc_us_
locust85312343loc_ust
loggish12258733loggish
logoi69715943logoi__
logons79818173logons_
logos67225333logo_s_
longish11229093longish
loofs85623783lo_ofs_
looie55624243lo_oi_e
looies65025833lo_oies
looing73621043lo_oing
lookisms1444793lookisms
lookist1139563lookist
looks95124863lo_oks_
looksism1442493looksism
loom67035053lo_o__m
looms75124643lo_oms_
loons55731723lo_ons_
loops75723963lo_ops_
loos49051123lo_o_s_
loose56627683lo_o_se
loots55431423lo_ots_
loris55329153lo_ris_
lotos54724633loto_s_
loudish1137983loudish
louis57322323lo_uis_
loutish1039963loutish
lowish12310533lo_wish
loyalism13167573loyalism
lyrism1137473l_yrism
machoism1746393machoism
mobbism1535053mobbism
momism93410353mo_mism
monism104016313mo_nism
moronism1249323moronism
nicoise937933nicoise
nomism103010953no_mism
obiism1036363_obiism
oboist8312683_oboist
ogrism937913_ogrism
pocosin1169643pocosin
poloist91016323poloist
porism104518063po_rism
racism103214193rac_ism
robotism1285963robotism
schism1338173_schism
soloist7915893soloist
sophism1437873sophism
tachism1478873tachism
tourism939423tourism
vocalism15159043vocalism

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271046.59320328.7
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.04525364.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.