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

121 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
loricate1031066(None) 
loricae938251lorica_e
loricated1247891loricated
loricates11310121loricates
corticate13410762corticate
floricane1444832floricane
forficate1745122forficate
fornicate1446082fornicate
locate83919842lo__cate
lorica8310442lorica__
lubricate1346442lubricate
muricate12311112muricate
sonicate10310932sonicate
suricate10312612suricate
abdicate1348903abdicate
affricate1744973affricate
bloviate1384913blovi_ate
boracite1249193boracite
borate85026153bor__ate
carinate103320243carinate
chlorinate1546123chlorinate
cogitate1148553cogitate
colocate12313443colocate
cordate10315223cor_date
corelate10516013corelate
corncake1645263corncake
coronate103018213coronate
corotate102813933corotate
coruscate1346053coruscate
dedicate12312803dedicate
delicate11315493delicate
derivate12311203derivate
dominate11312853dominate
extricate1869073extricate
fabricate1646833fabricate
floriated1347023flori_ated
floricanes1544843floricanes
fluoridate1464013fluoridate
fluorinate1365103fluorinate
foliate10513533foli_ate
foredate12310913foredate
formate123115093for_mate
fornicated1644823fornicated
fornicates1545843fornicates
frigate11311063_frigate
furcate12310453fur_cate
imbricate1545663imbricate
indicate11313353indicate
intricate11411193intricate
iodinate949343iodinate
irrigate967633irrigate
irritate867873irritate
labiate91313573labi_ate
laminate103014633laminate
lapidate1157903lapidate
lariat6629043lari_at_
lariated91212063lari_ated
lariats7615053lari_ats
levigate1246623levigate
levirate1147623levirate
levitate1137933levitate
ligate72519253l__igate
litigate948303litigate
lobate82915243lo__bate
lobulate1078833lobulate
locale83915653lo__cale
located103114183lo__cated
locater93113603lo__cater
locates93218813lo__cates
loculate101011403loculate
lodicule1143263lodicule
logical1038513logica_l
logicise1146113logicise
logicize2046043logicize
lorikeet1255643lorikeet
lubricated1545033lubricated
lubricates1446053lubricates
lyrate94112103lyr__ate
lyrical1236493lyrica_l
lyricise13889973lyricise
lyricize221038083lyricize
marinate103017783marinate
medicate13513243medicate
metricate1349923metricate
motivate1347693motivate
muriate9313363muri_ate
muricated1448243muricated
nominate10312473nominate
norite63221133nori__te
noviciate1444423noviciate
ocicat101412813_ocicat_
ocicats11137413_ocicats
opiate8513463_opi_ate
orate55133303_or__ate
ordinate9310253_ordinate
ornate6315143_or_nate
oxidate1537023_oxidate
plicate11314513_plicate
primate111516283_primate
private121513263_private
radicate11412873radicate
rubricate1346483rubricate
seriate73722473seri_ate
silicate10312623silicate
sonicated1248453sonicated
sonicates11410383sonicates
sorbate9311733sor_bate
soricine10710883soricine
sororate8411173sororate
spicate113214193_spicate
striate74218953stri_ate
suricates11311743suricates
toccate1138773to_ccate
torquate1745003torquate
tunicate103310043tunicate
urinate7315363_urinate
urticate1049863urticate
variate101316433vari_ate
vesicate131210053vesicate
vomicae1445303vomica_e
workmate1744673workmate

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621217.42019698.4
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.87222699.6
 
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.