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

152 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
lustral733965(None) 
austral73411511austral
lustra6358891lustra_
astral66919282_astral
australs8359532australs
claustral1143472claustral
dustrag945362dustrag
estral64716512_estral
gastral8329552gastral
lustful1045282lustful
lustrate8310442lustrate
lustre64011682lustr_e
lustred8359052lustred
lustres73013232lustres
lustrum945852lustrum
luteal64411482lu_teal
mistral91013642mistral
plastral1046912plastral
rostral7311332rostral
vestral104111012vestral
antral65719413_antral
astrals75515243_astrals
astray95615543_astray
augural856403augural
aural54428963au__ral
auroral7310473auroral
australes9317763australes
bestial9311643bestial
bustard10389723bustard
butyral1245713butyral
central93114473central
citral81113893_citral
claustra1043523claustra_
cloistral1143543cloistral
colostral1145493colostral
costal85419513cost_al
costrel9310373costrel
crustal939023crust_al
cultural1047263cultural
curtal83914543curt_al
cuspal1037883cus_pal
custard10389973custard
custumal12113593custumal
dextral1577003dextral
diastral946993diastral
distal73615773dist_al
ductal938993duct_al
dural64923893du__ral
dustman1044683dustman
dustpan1043243dustpan
dustrags1044943dustrags
estray95713333_estray
estrual7367933_estrual
festal94213563fest_al
funeral1037623funeral
fustian1036903fustian
futural1037283futural
gestural946033gestural
gluteal854243glu_teal
guttural943813guttural
humeral1238563humeral
humoral1237973humoral
instal6712193inst_al
jural125120483ju__ral
kestrel1137113kestrel
lacteal966813lacteal
lateral7313573lateral
lethal939803l_ethal
liberal9310193liberal
listel64214743list_el
literal7613273literal
litoral7610763litoral
littoral845273littoral
locustal10325223locust_al
loral55927823l__oral
lumenal9307273lumenal
luminal93711003luminal
lust47442603lust___
lusted74319443lust_ed
luster64023673lust_er
lustered92510603lustered
lusters73921443lusters
lustier73813503lustier
lustily103611243lustily
lusting83619323lusting
lustrated1037963lustrated
lustrates939463lustrates
lustring9269723lustring
lustrous877803lustrous
lustrums1044663lustrums
lusts55022803lust__s
lusty85417573lust__y
lutea54819073lu_tea_
mistrals101212623mistrals
mistrial10311383mistrial
mitral81314323_mitral
mural75225113mu__ral
musical1139553musical
muskrat1346733muskrat
mustard10359533mustard
mutual838503mu_tual
neutral737923neutral
nostril749303nostril
numeral939083numeral
nuptial946633nuptial
nurtural845493nurtural
olestra746173olestra_
olestras846583olestras
osteal6312963_osteal
outran63218893ou_tran
palestral1145323palestral
pastoral10310483pastoral
pastural1038413pastural
peytral1287503peytral
plural839823plu__ral
postal84317533post_al
postoral10311723postoral
postural1049203postural
puberal1147773puberal
quetzal2543013quetzal
restoral8810983restoral
retral64419743_retral
ristra6310713ristra_
ristras7311563ristras
rostra6310933rostra_
ruderal837373ruderal
rural55821173ru__ral
rustical1048393rustical
seral56336383__seral
sistra639333sistra_
steal56125473__steal
strap77925263__strap
straw813321293__straw
stray88525573__stray
subastral1144053subastral
suboral92011993suboral
sudoral8148543sudoral
sural55931263__sural
sutra54217933su_tra_
sutras64818593su_tras
sutural7310223sutural
tumoral938133tumoral
tussal6288323tus_sal
ultra539363_ultra_
ultras6310193_ultras
umbral1038633_umbral
unstrap946783unstrap
usual5310183_us_ual
ventral103612173ventral
vestal94615573vest_al
vestural1156473vestural
wastrel1037553wastrel

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.423422437.4
2DLD Change Limit1340271526.09321996.9
3Display Results1521520.0632412.7
 (SQL Overall)1786911526.57927160.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.