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

224 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
lanital731091(None) 
lanitals837721lanitals
animal85016252_animal
cantal84122032can_tal
capital112311522capital
genital849792genital
labial84714342labi_al
laical8312322la_ical
laminal94113632laminal
marital92314182marital
acetal84314903_acetal
agita6315423_agita_
agitas7310593_agitas
albinal937813albinal
amanita9310453amanita_
amanitas1048533amanitas
anal48037523_an__al
anginal8310163_anginal
anil46437433_ani__l
anima74620073_anima_
animals94111703_animals
animas84418723_animas
annal56520763_an_nal
anneal64812293_anneal
annual64710703_annual
anodal72512123_anodal
anta46839583_an_ta_
antae56828293_an_tae
antas55432033_an_tas
antiar6317173_antiar
antitax1447853_antitax
antral65719413_antral
anural65714743_anural
aortal65217513_aortal
apical10913903_apical
artal55525473_a_rtal
axial124515193_axi_al
banal75925993ban__al
bangtail1144353bangtail
banian8315383bani_an
bantam10314063ban_tam
barbital1247053barbital
basinal9310033basinal
bonita8312943bonita_
bonitas939453bonitas
canal75428043can__al
candidal12367733candidal
canistel10187253canistel
cannibal1245203cannibal
cantala94114673can_tala
cantals93919573can_tals
canthal12410053canthal
capita102913773capita_
capitals12209443capitals
capitol11258283capitol
carinal94318233carinal
caritas93316953caritas
carnival1345613carnival
casita82913703casita_
casitas93312043casitas
cental84420963cen_tal
chital114313883_chital
clinical1247023clinical
coital84117053_coital
conical11316203conical
cranial92114683crani_al
cubital1137103cubital
cynical1437873cynical
datival1135583datival
denial74720513deni_al
dental74319173den_tal
digital937063digital
facial113615633faci_al
fajita1635923fajita_
fajitas1734253fajitas
fantail10310233fan_tail
fatal84819373fa__tal
finial92814183fini_al
finical1239693finical
fontal9313143fon_tal
gametal1037603gametal
gavial10310083gavi_al
genial74917613geni_al
genitals937243genitals
glacial1038143glaci_al
granita82111303granita_
granitas92610223granitas
habitan1236903habitan
habitat12411053habitat
habitual1343493habitual
hangtag1244533hangtag
haniwa1236743haniwa_
hartal9415473ha_rtal
initial7311883_initial
instal6712193_instal
invital1046953invital
janitor1436483janitor
kantar10311153kan_tar
labia75219013labi_a_
labials9299873labi_als
labiate91313573labiate
lacrimal1244443lacrimal
lactam10310943la_ctam
lacteal966813lacteal
lacunal9136553lacunal
laith85722103la_it_h
laithly1335653la_ithly
laity85318903la_it_y
lamia75324323lami_a_
lamiae84817453lami_ae
lamias85020613lami_as
lamina84920443lamina_
laminae93512973laminae
laminals10339303laminals
laminar93810283laminar
laminas93615873laminas
lanai5319573lan__ai
lanate6421263lanat_e
lanated8313203lanated
landau7310613lan_dau
landfall1244203landfall
landman1038923landman
laneway1345273laneway
langrel8107033langrel
laniard868523laniard
laniary1068013laniary
lantana739603lan_tana
lariat6629043lari_at
lariats7615053lariats
larval948503la_rval
lateral7313573lateral
latilla737953latilla
latina65621143latina_
latinas74416463latinas
laxity1637273laxit_y
lenite6719983lenit_e
lenited8812433lenited
lenites7818443lenites
lenity9612713lenit_y
lentil64315393len_til
lexical1637363lexical
liminal93810673liminal
lineal65616023lin_eal
lingual8379083lingual
lintel64013993lin_tel
lintol6369473lin_tol
litai55216363l__itai
litas54923773l__itas
logical1038513logical
luminal93711003luminal
lunitidal1043183lunitidal
lyrical1236493lyrical
magical1239783magical
mania75634153mani_a_
maniac103917973mani_ac
maniacal1246723maniacal
manias84029033mani_as
manila84518303manila_
manilas93915873manilas
manilla93012473manilla
manito8518693manit_o
manitos9314053manitos
manitou938463manitou
manitu8315823manit_u
manitus9310923manitus
mannitol1044043mannitol
manta75629913man_ta_
mantas85725363man_tas
mantel84317973man_tel
manual8313463man_ual
martial92415413martial
matinal9312603matinal
maximal18347093maximal
menial84223033meni_al
mental84521603men_tal
minimal114010603minimal
nadiral836343nadiral
narial6317953nari_al
nasial6413283nasi_al
natal53921493__natal
nidal65217103__nidal
nival84915773__nival
nonvital1147023nonvital
notal55221353__notal
orbital936923orbital
paginal10269493paginal
palatal9310153palatal
parietal1048773parietal
partial92616263partial
penial84120893peni_al
pinitol936683pinitol
plantar9369993plan_tar
quantal16367893quan_tal
quintal16389883quintal
racial83419243raci_al
radial74020393radi_al
radical103312793radical
raita54623073ra_ita_
raitas64417673ra_itas
ratal55025113ra__tal
recital9412163recital
rental63922023ren_tal
sagittal943283sagittal
sahiwal1344443sahiwal
sancta839833sancta_
sandal73317283san_dal
sanitary1146753sanitary
sanitate8612043sanitate
sanity9316203sanit_y
santol64515243san_tol
somital939403somital
spital83813873_spital
tapetal938273tapetal
vaginal11288403vaginal
vandal103713833van_dal
vanilla10238743vanilla
vanity12311933vanit_y
varietal1145613varietal
vatical1239983vatical
venial94218283veni_al
vital84819673__vital
wanigan1135213wanigan
xenial133414903xeni_al
zenithal2093333zenithal

Search took 7 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.390458182.1
2DLD Change Limit1340272246.28021341.9
3Display Results2242240.0802800.0
 (SQL Overall)1786912246.75026472.7
 
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.