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

293 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
lateral731357(None) 
laterad8310841laterad
laterals8312751laterals
literal7613271literal
apteral9311522apteral
bilateral1144982bilateral
cameral11311282cameral
cateran9313772cateran
enteral73516442enteral
lacteal966812lacte_al
later54843922later__
lateraled1047452lateraled
laterally1248072laterally
liberal9310192liberal
literals8312292literals
litoral7610762litoral
luteal64411482lute_al
material10314102material
maternal1047802maternal
natural739512natural
paternal1038332paternal
aboral8314373_aboral
acetal84314903_acetal
aerial64625713_a_erial
alter54828503alter__
alterable1149163alterable
alterably1447203alterably
alterant8614963alterant
altered83215733altered
alterer72713993alterer
alters64924223alter_s
amoral8314633_amoral
antheral1149393antheral
antral65719413_antral
anural65714743_anural
areal55928733_are_al
arterial8313633arterial
asternal858323asternal
astral66919283_astral
atabal839743_atabal
atonal6514023_atonal
atrial65418943_atrial
aural54428963_a_ural
bacterial1348363bacterial
bateau8810563bate_au
bathyal1544823bathyal
blastemal1343783blastemal
butyral1245713butyral
caecal103713733ca_ecal
camera10313693camera_
camerae11312063camerae
cameras11313363cameras
caporal11410943caporal
carceral1247203carceral
catena8312483catena_
catenae9311373catenae
catenas9313113catenas
cater74840723cater__
caterans10313223caterans
catered103117773catered
caterer92815943caterer
caters85336503cater_s
caterwaul1442943caterwaul
cathedral15104383cathedral
chapteral1644703chapteral
citral81113893cit_ral
clitoral10106463clitoral
collateral1244113collateral
daedal849083da_edal
dater65332313dater__
daters74827373dater_s
datival1135583datival
datura738023datura_
daturas838773daturas
dipteral1147003dipteral
eater54639843eater__
eaters65535953eater_s
eatery95316353eater_y
elater64724203elater__
elaterid948613elaterid
elaterin849903elaterin
elaters74420193elater_s
entera64216833entera_
enthral103410933enthral
estral64716513est_ral
eternal72910893_eternal
external1577223external
faecal11359813fa_ecal
falderal12104803falderal
fatal84819373fat__al
fateful1397513fateful
federal1148533federal
feral85424653__feral
fraternal1243873fraternal
funeral1037623funeral
futural1037283futural
gametal1037603gametal
gastral8329553gastral
gateau778113gate_au
gateman1057473gateman
gater64533653gater__
gaters74728643gater_s
gateway1434933gateway
general81010933general
gluteal854243glute_al
gomeral1038833gomeral
haemal113811643ha_emal
hateful13107683hateful
hater85034753hater__
haters94930403hater_s
haverel13397153haverel
humeral1238563humeral
integral946783integral
internal8414083internal
interval11710463interval
inthral10249463inthral
labara83712893labara_
label75019383labe__l
labella988943labella
labial84714343la_bial
labra75415463la_bra_
lacer75833753lacer__
lacerable1346943lacerable
lacerate102214703lacerate
lacers85225253lacer_s
lacteals1095663lacte_als
lactean956473lacte_an
lacunal9136553lacunal
lader65633723lader__
laders74927763lader_s
laetrile845193laetrile
lager65132863lager__
lagered92311153lagered
lagers74826143lager_s
laical8312323la_ical
laker95432873laker__
lakers105225153laker_s
lamella988613lamella
lamer75233703lamer__
laminal94113633laminal
laneway1345273laneway
langrel8107033langrel
lanital7310913lanital
lantern7310013lanter_n
lanterns838303lanterns
lapel73716683lape__l
larval948503la_rval
laser54633323laser__
lasers64925703laser_s
laster64830633laster__
lasters75627693laster_s
late47560483late___
lated65240673late__d
lateen64014863late_en
lateens74210553lateens
lately93413843late_ly
laten54328343late__n
latency1236033latency
latened8711923latened
latens64620213late_ns
latent64124303late_nt
latently1146353latently
latents75214313latents
lateraling11148803lateraling
lateralize1949053lateralize
lateralled1144783lateralled
laterite8716333laterite
laterize17613293laterize
latest63822703late_st
latests73910313latests
latex124717113late__x
latexes1438313latexes
lather95124353lather__
lathered121512323lathered
latherer111310443latherer
lathers104321883lather_s
lathery133911123lather_y
latilla737953latilla
latina65621143latina_
latinas74416463latinas
latosol745283latosol
latria62313593lat_ria
latrias71913213latrias
latter65027893latter__
latterly1136063latterly
laura54116203la_ura_
laurae64011663la_urae
lauras63414333la_uras
laurel649033la_urel
laver85031793laver__
lavers94526363laver_s
laxer125420333laxer__
layer84626473layer__
layerage1244963layerage
layered11259413layered
layers93921183layer_s
leal46043273l__e_al
legal65715943l__egal
lethal939803let_hal
liberals1039413liberals
lienal63912783l_ienal
lineal65616023line_al
liter54736343liter__
literacy1346803literacy
literally1248343literally
literary1147753literary
literate81216893literate
literati81210803literati
liters65429883liter_s
littoral845273littoral
loral55927823l__oral
loreal63814313lore_al
lumenal9307273lumenal
lustral7339653lustral
lutea54819073lute_a_
mater74438863mater__
materials11510793materials
materiel10311253materiel
maters85032393mater_s
matinal9312603matinal
mayoral1237693mayoral
mineral9312733mineral
mitral81314323mit_ral
nadiral836343nadiral
natal53921493nat__al
naturals847903naturals
numeral939083numeral
oater55433733oater__
oaters65029793oater_s
oatmeal944973oatmeal
osteal6312963oste_al
paleal84716673pale_al
papyral1445773papyral
parral85517533pa_rral
pastoral10310483pastoral
pastural1038413pastural
patella938953patella
pater74740723pater__
paters84935833pater_s
patrol83213023pat_rol
plastral1046913plastral
plateau937403plate_au
plateful1345433plateful
plater84427693plater__
platers93924093plater_s
puberal1147773puberal
ratal55025113rat__al
ratel54224883rate__l
rater54943283rater__
raters63936583rater_s
rattrap945263rattrap
retral64419743ret_ral
ruderal837373ruderal
sacral83414413sa_cral
santera7311303santera_
santeras8311063santeras
satara6315533satara_
sataras7315063sataras
satrap86212553sat_rap
scleral937863scleral
seral56336383__seral
several1039533several
slater64429183slater__
slaters73123733slater_s
spheral1238423spheral
steal56125473_ste_al
sternal73411913_sternal
sterol6613333_sterol
sutural7310223sutural
tapetal938273tapetal
tater54138613tater__
taters64932203tater_s
teal45546503__te_al
tepal76319583__tepal
terai53525483__terai
tergal72912833__tergal
trilateral1053623trilateral
tuatera756373tuatera_
tuateras836193tuateras
unilateral1063493unilateral
ureteral856233ureteral
vatical1239983vatical
veteran1039353veteran
water84733313water__
waterage1248663waterage
watered113014953watered
waterer103314073waterer
waterfall1544583waterfall
waterily1438783waterily
waterman1397283waterman
waters95030633water_s
waterway1745563waterway
watery123914493water_y

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 Limit1340272937.04619021.7
3Display Results2932930.0933150.5
 (SQL Overall)1786912937.54523683.4
 
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.