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

94 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
lochial125708(None) 
lochia1158311lochia_
ischial1246422ischial
local74820272loc__al
lochan1139092loch_an
mochila1446522mochila
rachial122012172rachial
social8813332soc_ial
achiral12109183_achiral
aecial84817313aec_ial
alodial899953alo_dial
archil11611573archi_l
archival1645783archival
asocial998653asoc_ial
boccia12338793boccia_
boccias13307193boccias
brachial15219303brachial
bronchial16175333bronchial
chia96026623__chia_
chiao105618363__chiao
chias104625523__chias
chiel104918973__chiel
chill105619873__chill
chiral114614413__chiral
chital114313883__chital
coaxial16157003coaxial
coccal9310223coc_cal
cochair1446313cochair
cochin131313203cochi_n
cochineal1643513cochineal
cochins141413103cochins
conchal144211583conch_al
cordial10312943cordial
decrial10310323decrial
epochal1445243epoch_al
facial113615633fac_ial
fecial114714623fec_ial
focal104917673foc__al
glacial1038143glac_ial
glochid1445263glochi_d
glochids1543953glochids
ischia1136393ischia_
jovial1636543jo_vial
labial84714343l_abial
lacrimal1244443lacrimal
lacteal966813lacteal
lacunal9136553lacunal
leching134613653leching
lethal939803leth_al
lichi104412953lichi__
lichis115212593lichi_s
lithia939333lithia_
lithias1038823lithias
loca65527683loc__a_
locale83915653loc__ale
locals83714503loc__als
loch95527133loch___
lochans1248833lochans
lochs106715513loch__s
loci66126283loc_i__
locking143718153locking
lockjaw2341823lockjaw
lockram1544913lockram
locoing102810973locoing
locoism1156793locoism
locular938953locular
locustal10325223locustal
loessal744393loessal
loessial843783loessial
loggia8457053loggia_
loggias9356783loggias
logia68116603lo_gia_
logical1038513logical
loral55927823lo__ral
loreal63814313lo_real
loyal84513483lo__yal
mocha1249923moch_a_
mochas13310663moch_as
mochilas1544953mochilas
nuchal11218873nuch_al
octal71214723_oc_tal
ohia75719363_o_hia_
ohias84415573_o_hias
orchil1158653orchi_l
parochial1646183parochial
phial10313203__phial
racial83419243rac_ial
rhonchial1752263rhonchial
socials999633soc_ials
trochal1288243troch_al
trochil1258713trochi_l
uncial83715223unc_ial
vocal104715643voc__al
zoarial1646923zoarial

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 Limit134027946.81319672.2
3Display Results94940.0303133.3
 (SQL Overall)178691947.24924650.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.