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

288 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
allured829917(None) 
alluded9327091alluded
allure63012941allure_
allurer7348431allurer
allures72913111allures
abjured1735082abjured
abluted10188362abluted
adjured1634882adjured
allayed11138062allayed
alleged9389322alleged
allied74217152all_ied
allowed111610082allowed
alloyed11158032alloyed
allseed835952allseed
allude73910902allude_
alludes83610332alludes
allurers8286772allurers
altered83215742altered
assured858372assured
augured987192augured
callused1135852callused
cloured103111542cloured
floured11289872floured
gallused1034192gallused
illuded9305762illuded
illumed10285862illumed
loured74617402_loured
lured65427492__lured
velured1136682velured
abduced1374843abduced
abjure1536743abjure_
abjurer1634753abjurer
abjures1636523abjures
ablated102513443ablated
abled86926833abl__ed
absurd935903absur_d
abused95614273a_bused
accrued1233823accrued
accursed1354633accursed
accused12368423accused
acquired2044043acquired
acred87126353a__cred
adduced1274353adduced
adhered1239233adhered
adjure1435843adjure_
adjurer1534823adjurer
adjures1536233adjures
admired1135703admired
adored84714243a_dored
afeared1176833afeared
aglare7312433aglare_
ailed66240283ail__ed
aired66032923a__ired
alarmed1037743alarmed
alarumed1143323alarumed
alated75625153a_lated
albumen1135243albumen
alcoved1375623alcoved
alerted82512223alerted
aleuron757383aleuron
alfredo1142483a_lfredo
alibied1038143alibied
aliened81011743aliened
aligned9128553aligned
alined75221403a_lined
aliped95414283a_liped
aliunde835003aliunde
allayer10148213allayer
allee54932123all__ee
allees64521483all_ees
allege74314653allege_
alleger8319633alleger
alleges84212573alleges
allele64514563allele_
alleles73812033alleles
allergen9135893allergen
allergy1144503allergy
alley85721673all__ey
allies63827673all_ies
allod64418383all__od
allotted986873allotted
allover1038583allover
allseeds943393allseeds
alluring939073alluring
alluvia1045193alluvia
almuce10348213almuce_
almuces11316823almuces
almud84012183almu__d
almude9399933almude_
almudes10418263almudes
aloud65018073alou__d
alterer72714003alterer
aludel747863a_ludel
alulae6312743alulae_
amused94412513a_mused
aneared8512743aneared
angered93013473angered
antired82316193antired
antlered938263antlered
arbored103811603arbored
arboured1156253arboured
argued84311173argu_ed
armored102610473armored
armoured1165223armoured
armure8710133armure_
armures9510273armures
aroused84914343aroused
ascared10399523ascared
ashlared1253933ashlared
ashlered1244623ashlered
aspired1068173aspired
assumed1065293assumed
assure6610773assure_
assureds984493assureds
assurer767793assurer
assures7611403assures
attired8238913attired
attuned835173attuned
augurer8136343augurer
aurei54821863a__urei
aures55137093a__ures
averred11237593averred
avulsed1133833avulsed
axled135315813axl__ed
azure14911483a_zure_
azures15510183a_zures
balled94926893ball__ed
balloted1189043balloted
ballute938543ballute_
ballutes1037523ballutes
blared95018243_blared
bleared104211253bleared
bloused104310643bloused
blued84520323_blu_ed
blumed114313643_blumed
blurbed12337613_blurbed
blurred10427803blurred
blurted10399783_blurted
calibred1335053calibred
called94126733call__ed
calloused1244403calloused
calluses1039323calluses
calqued19306523calqu_ed
captured1336573captured
cellared11398793cellared
cleared103612463cleared
closured11266353closured
clotured11246163clotured
clouded11348833clouded
clouted104212163clouted
clued84917683_clu_ed
collared113211143collared
colluded12296463colluded
colored10313473colored
coloured1148313coloured
colure8314163colure_
colures9315143colures
cultured1137233cultured
cured85932133__cured
dallied93713613dall_ied
deluded10158763deluded
deluged10167413deluged
diluted9248933diluted
dured75025403__dured
eluded84612773_eluded
eluted74915263_eluted
endured93611213endured
ensured83512943ensured
enured73315333_enured
failure1035753failure_
failures1135163failures
fallowed15127753fallowed
faltered122810993faltered
favoured1533963favoured
figured12196473figured
flared105317603_flared
fleered11309503fleered
floored11268683floored
flouted113210813flouted
flued95021253_flu_ed
fluked145112093_fluked
flumed124915263_flumed
fluted104917163_fluted
fluxed17509673_fluxed
fullered1236383fullered
galled84622863gall__ed
galleried1146933galleried
galleted1038223galleted
gallied94115003gall_ied
galloped12107153galloped
galluses936963galluses
glaired9387753glaired
glared84715203_glared
glouted9429713glouted
glued75118363_glu_ed
hachured1744393hachured
halloaed121510153halloaed
halloed113314913hall_oed
hallooed12168773hallooed
hallowed15179493hallowed
halluces1335613halluces
haltered123112563haltered
hollered1237603hollered
illude7327503illude_
illudes8347553illudes
illume8298223illume_
illumes9327673illumes
immured1235063immured
injured15339063injured
insured83714253insured
inured73114813_inured
kluged12427233_kluged
labored102810253labored
laboured1156333laboured
lagered92311153lagered
laired75216813_laired
lalled74218753lal_led
lauded83812153_lauded
laurel649033_laurel
layered11259413layered
leered73816223_leered
louped95316383_louped
loused74822913_loused
louted74920693_louted
louvred11354663_louvred
lubed85319893__lubed
luged74019093__luged
lulled74516443_lulled
lure45142463__lure_
lurer54625313__lurer
lures56138533__lures
lurex124816733__lurex
lurid64618973__lurid
lurked114511973__lurked
luted64826143__luted
mallard10310273mallar_d
malled94626113mall__ed
manured1039473manured
matured10310043matured
mured85726703__mured
natured838963natured
palled94625163pall__ed
palleted1139873palleted
paltered113012493paltered
pastured1138233pastured
pillared11228093pillared
plumed114412883_plumed
polluted1135433polluted
poured95116743_poured
rallied83514083rall_ied
raptured1155473raptured
relumed1069813relumed
sallied83316953sall_ied
sallowed12149033sallowed
saluted84511713saluted
savoured1234793savoured
scoured103811153scoured
secured1059723secured
silurid837013silurid
slued64220513_slu_ed
slurped10368753_slurped
slurred8359193slurred
soured74921863_soured
splurged1243923splurged
sulfured1236113sulfured
sutured8310373sutured
taboured1156273taboured
tailored936203tailored
tallaged10257923tallaged
tallied83314753tall_ied
tallowed12157713tallowed
tenured838363tenured
tillered937443tillered
toured74216153_toured
ulcered1037973ulcered
ullaged937033ullaged
uncured10513233uncured
valleyed1534013valleyed
valued104011153valu_ed
vapoured1434353vapoured
velure939773velure_
velures1039093velures
volumed13285683volumed
voluted11297943voluted
walled104021293wall__ed
walleyed1534153walleyed
walloped14146833walloped
wallowed15148163wallowed

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.423422437.4
2DLD Change Limit1340272886.86019537.5
3Display Results2882880.0933096.8
 (SQL Overall)1786912887.37624226.0
 
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.