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

139 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
loricae93825(None) 
lorica8310441lorica_
loricate10310661loricate
floricane1444832floricane
logical1038512logical
loricated1247902loricated
loricates11310132loricates
lyrical1236492lyrical
vomicae1445302vomicae
alogical1147763alogical
aortae65115473aor_tae
auricle9139813auricle
bodice11711423bodic_e
boric98024223boric__
boride9415903bori_de
carinae94318593carinae
clerical1248233clerical
cloacae1145233clo_acae
comical13312223comical
conical11316203conical
coracle112011723coracle
coria75828323cori_a_
corncake1645263corncake
cornice11612933cornic_e
corniche1575923corniche
cornicle1258783cornicle
coronae94214893coronae
cortical12412213cortical
corticate13410773corticate
curiae84518373curi_ae
domical1239373domical
dormice1237133dormic_e
erica7316543_erica_
ericas8315463_ericas
feriae95618603feri_ae
florae94713883flor__ae
floricanes1544843floricanes
force105324273for_c_e
forficate1745123forficate
formica1436443formica_
formicas1546003formicas
fornical1347793fornical
fornicate1446083fornicate
gloria71910553glori_a_
glorias81610323glori_as
gloriole944303gloriole
laical8312323l_aical
lamiae84817453lami_ae
laminae93512973laminae
lariat6629043lari_at
larine63927043lari_ne
larvae938843lar_vae
leporidae1252983leporidae
lexica1536103lexica_
lexical1637363lexical
lice66045063l__ic_e
licorice1246143licoric_e
liriope944043liriope
loca65527683lo__ca_
local74820273lo__cal
locale83915653lo__cale
locate83919843lo__cate
lodicule1143263lodicule
logia68116603logi_a_
logic88217833logic__
logician1145223logician
logicise1146113logicise
logicize2046043logicize
logics95711123logic_s
looie55624243looi__e
loral55927823lor__al
loran55925093lor__an
lore45850353lor___e
loreal63814313lor_eal
lories64933043lori_es
lorikeet1255643lorikeet
lorimer937753lorimer
loriner7511893loriner
loris55329153lori__s
lorises73918593lorises
lotic76420673lotic__
louche115212663lo_uche
louie55023513loui__e
lubrical12116093lubrical
lubricate1346443lubricate
lyric104512723lyric__
lyricise13889973lyricise
lyricize221038083lyricize
lyricon1243713lyricon
lyrics11357943lyric_s
modica11310063modica_
morae75831193mor__ae
mortice11711493mortic_e
morulae958963morulae
muricate12311113muricate
myrica1336833myrica_
myricas1436753myricas
nodical1049863nodical
noria55722183nori_a_
norias65518203nori_as
norite63221133nori_te
notice8313443notic_e
novice1138433novic_e
ocicat101412813_ocicat
oorie53026363oori__e
orache114013593_orache
oracle84313293_oracle
orca65522773_or_ca_
orcas75918623_or_cas
origan7310693_origan
oriole6814293_oriole
orrice81410163orric_e
plicae10410953_plicae
police102918563polic_e
porcine11312843porcine
potiche1438043potiche
price93725413_pric_e
rice64942913__ric_e
scoriae9310903scori_ae
sonicate10310933sonicate
soricine10710883soricine
soroche1237183soroche
spicae104313703_spicae
striae65422273stri_ae
suricate10312613suricate
thrice114311573thric_e
topical1139953topical
toric76529313toric__
torics85118353toric_s
torulae758553torulae
toxical1637643toxical
trice75127493_tric_e
tunicae9328143tunicae
utricle937913utricle
vesicae12177703vesicae
voice104915323vo_ic_e
vomica1336383vomica_
vortical1348863vortical
zorille1636673zorille

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.420425454.8
2DLD Change Limit1340271396.86019537.5
3Display Results1391390.0463021.7
 (SQL Overall)1786911397.32624391.3
 
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.