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

137 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
litoral761076(None) 
clitoral10106461clitoral
literal7613271literal
littoral845271littoral
citral81113892cit_ral
lateral7313572lateral
liberal9310192liberal
literals8312292literals
littorals944132littorals
loral55927822l__oral
mitral81314322mit_ral
aboral8314373_aboral
amoral8314633_amoral
antral65719413ant_ral
apteral9311523apteral
astral66919283ast_ral
atonal6514023_atonal
auroral7310473auroral
bifocal1445373bifocal
bimodal1245663bimodal
bizonal1845563bizonal
boral75831703__boral
butyral1245713butyral
caporal11410943caporal
chloral12169983chloral
choral115118493_choral
citola838393citola_
citolas939363citolas
citrals91111673cit_rals
clitoric1246603clitoric
clitoris1047873clitoris
coral76033453__coral
dipteral1147003dipteral
doctoral1146303doctoral
editorial1047313editorial
electoral1156723electoral
enteral73516443enteral
enthral103410933enthral
ephoral1248403ephoral
estral64716513est_ral
femoral1238723femoral
figural1145243figural
floral94313813_floral
futural1037283futural
gooral7310463_gooral
goral65125753__goral
horal86328683__horal
humoral1237973humoral
immoral1146783immoral
inthral10249463inthral
ixora1236913_ixora_
ixoras1337193_ixoras
kilorad1245393kilorad
laterad8310843laterad
laterals8312753laterals
latosol745283latosol
lethal939803let_hal
liberals1039413liberals
libra74712423li_bra_
librae84310173li_brae
libras83711703li_bras
lictor83610853lictor__
lictorian1166603lictorian
lictors93212593lictor_s
lienal63912783li_enal
liminal93810673liminal
lineal65616023li_neal
lingual8379083lingual
lintol6369473linto__l
lipoidal1144473lipoidal
lipoma1046753lipoma_
lipomas1156443lipomas
lira46928683li__ra_
liras56021983li__ras
litai55216363lit__ai
litas54923773lit__as
liter54736343liter__
literacy1346803literacy
literally1248343literally
literary1147753literary
literate81216893literate
literati81210803literati
liters65429883liter_s
lithia939333lithia_
lithias1038823lithias
lithoidal1343753lithoidal
lithosol1143313lithosol
litotes7311183litotes
litotic939243litotic
litre55421463lit_r_e
litres65220393lit_res
liturgy1142873liturgy
local74820273l__ocal
loran55925093l__oran
loreal63814313l__oreal
loyal84513483l__oyal
lustral7339653lustral
luteal64411483lut_eal
mayoral1237693mayoral
mineral9312733mineral
mistral91013643mistral
moral75533433__moral
natural739513natural
nitril62511533nit_ril
nonoral7313603nonoral
oral47638123___oral
pastoral10310483pastoral
pectoral121210503pectoral
peroral9314793peroral
pictorial1348403pictorial
pivotal1245433pivotal
postoral10311723postoral
preoral9312673preoral
restoral8810983restoral
retotal739843retotal
retral64419743ret_ral
ritual6310623rit_ual
sectoral10109543sectoral
sororal7310653sororal
sporal82915453_sporal
stomal85213313_stomal
storax1389783_storax
suboral92011993suboral
sudoral8148543sudoral
sutural7310223sutural
timbral11237193timbral
tonal53724303__tonal
tora47545993__tora_
torah87125273__torah
toras55540373__toras
total55321823__total
tumoral938133tumoral
tutorial847833tutorial
unmoral948693unmoral
viral86419593vi__ral
vital84819673vit__al
withal1238933wit_hal

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 Limit1340271377.09318895.7
3Display Results1371370.0502740.0
 (SQL Overall)1786911377.54923670.8
 
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.