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

136 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
logical103851(None) 
alogical1147761alogical
comical13312222comical
conical11316202conical
domical1239372domical
illogical1245412illogical
laical8312322l_aical
lexical1637362lexical
local74820272lo__cal
logia68116602logi_a_
logic88217832logic__
logically1548972logically
logician1145222logician
logics95711122logic_s
lorica8310442lorica_
loricae938252loricae
lyrical1236492lyrical
magical1239782magical
nodical1049862nodical
ogival1035872_ogival
oological1248322oological
topical1139952topical
toxical1637642toxical
alodial899953alodi_al
alogically1648793alogically
analogical1356363analogical
anginal8310163anginal
apical10913903_apical
atomical1248903atomical
biological15128883biological
biotical1248863biotical
clerical1248233clerical
clinical1247023clinical
cloacal1135163clo_acal
coccal9310223co_ccal
codicil1246813codicil
coital84117053co_ital
cortical12412213cortical
cosmical1448013cosmical
cotidal1038463cotidal
cubical1338463cubical
cynical1437873cynical
dialogical1445513dialogical
digital937063digital
domicil1246433domicil
ecological1548703ecological
elegiacal1252133elegiacal
enological1348883enological
epical10413393_epical
erotical101911983erotical
ethical1238443ethical
finical1239693finical
focal104917673fo__cal
fornical1347793fornical
geological1448073geological
georgical1344023georgical
gnomical1346683gnomical
helical12311153helical
iconical1248203iconical
ironical1049963ironical
jovial1636543jovi_al
labial84714343labi_al
laminal94113633laminal
lanital7310913lanital
legal65715943leg__al
lexica1536103lexica_
liminal93810673liminal
loca65527683lo__ca_
locale83915653lo__cale
locals83714503lo__cals
lochial1257083lochial
lodicule1143263lodicule
loessal744393loessal
logan68123283log__an
loggia8457053loggia_
loggias9356783loggias
logicality1644183logicality
logicians1244173logicians
logicise1146113logicise
logicize2046043logicize
logier75015733logi_er
logiest82515543logiest
logily1039833logi_ly
login66025003logi__n
logins77820643logi_ns
logion76013723logi_on
logions86211293logions
logistical1355043logistical
logjam1635363log_jam
logroll844263logroll
logway1335913log_way
loral55927823lo__ral
loreal63814313lo_real
loricate10310663loricate
lotic76420673lotic__
loyal84513483lo__yal
lubrical12116093lubrical
luminal93711003luminal
medical12312513medical
metical11315363metical
mimical1339233mimical
modica11310063modica_
musical1139553musical
nominal92712373nominal
nonlogical1347063nonlogical
ocicat101412813_ocicat
optical1149863optical
paginal10269493paginal
pical95524373__pical
plical10411683_plical
poetical12311533poetical
pollical1247953pollical
prelogical1546693prelogical
radical103312793radical
reginal84814293reginal
social8813333soci_al
somital939403somital
stoical9310283stoical
surgical1146253surgical
tical76021493__tical
tragical1148213tragical
tropical1248733tropical
typical1436343typical
ufological1644903ufological
urological1347753urological
vaginal11288403vaginal
vatical1239983vatical
vesical12159813vesical
vocal104715643vo__cal
vomica1336383vomica_
vomicae1445303vomicae
vortical1348863vortical
yogic116114933yogic__
zodiacal2042243zodiacal
zooidal1745093zooidal
zoological2246443zoological

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.470380193.6
2DLD Change Limit1340271367.18618651.1
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.71923149.5
 
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.