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

344 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
availed113597(None) 
vailed104619291_vailed
ailed66240282__ailed
anviled1138952anviled
ariled75620322a_riled
assailed945322assailed
avail8313882avail__
avails939692avail_s
aviated11310262aviated
avoided1235552avoided
awaited1146962awaited
bailed94726652_bailed
brailed103914012brailed
camailed1336552camailed
caviled1348722cav_iled
emailed10359212emailed
failed105421602_failed
flailed1137302flailed
hailed104122742_hailed
jailed144917422_jailed
mailed95326752_mailed
nailed74021492_nailed
quailed1737822quailed
railed74727542_railed
reavailed1344002reavailed
sailed74327762_sailed
snailed83811922snailed
tailed74424662_tailed
trailed83415672trailed
travailed1344222travailed
veiled103714542_veiled
vialed105112592_vialed
wailed104823592_wailed
aahed917816443a_a_hed
abased96514993aba_sed
abashed1357663abashed
abated95918453aba_ted
abaxile1644083abaxile_
abided105313313a_bided
abled86926833__abled
abseiled1144733abseiled
adapted1135843adapted
addled94112523a_ddled
admired1135703admired
admixed1833733admixed
advanced1543313advanced
advised12136043advised
aedile73716653aedile_
aediles83413903aediles
aeried74221863aeri_ed
affined1436413affined
affixed2134123affixed
afield1035953a_field
agatized1947073agatized
agile65122263a_gile_
agnized18247223agnized
aided75828933__aided
aimed85626053__aimed
aired66032923__aired
airmailed1242903airmailed
aisled74516183a_isled
alarmed1037743alarmed
alated75625153ala_ted
alined75221403a_lined
aliped95414283a_liped
allied74217153alli_ed
amassed10388633amassed
amazed18519313ama_zed
ambled115116373a_mbled
aneled74719283a_neled
angeled93211513angeled
angled84219093a_ngled
anile54634463a_nile_
ankled114313483a_nkled
antired82316193antired
anvilled1236483anvilled
appalled1344813appalled
applied1247483applied
arabized2047173arabized
arable81821003arable_
arables91814973arables
argled85314553a_rgled
arrived11127353arrived
articled1137063articled
aspired1068173aspired
assailer844823assailer
assoiled935023assoiled
attained997353attained
attired8238913attired
audibled12224093audibled
audile73315303audile_
audiles83112613audiles
audited939033audited
auricled11135703auricled
availing1267283availing
avarice1238033avarice_
avarices1337183avarices
avenged1245503avenged
averred11237593averred
averted112211613averted
avianized2245083avianized
aviate9315203aviate_
aviates10313063aviates
avid88325963av_i__d
avoid95516683avoi__d
avoider1155813avoider
avowed1335963av_owed
avulsed1133833avulsed
awaiter1057443awaiter
awaked14579203awa_ked
awarded1236223awarded
awhile1257793awhile_
axile126020513a_xile_
axised14438963a_xised
axled135315813__axled
azalea1537003aza_lea
bailee84526013_bailee
bailer85425253_bailer
bailey115015673_bailey
baited95319243_baited
baled85436443_ba_led
balled94926893_balled
bawled124415693_bawled
bewailed1435343bewailed
boiled95020953_boiled
braided114013213braided
brailled1147193brailled
brained103816103brained
braised104014803braised
brawled133910123brawled
broiled103811423broiled
caballed1337163caballed
cabled114819873_cabled
called94126733_called
canaled103615563cana_led
canalled1139583canalled
cavalier1348183cavalier
caviler1249063cav_iler
cavilled1436733cavilled
ceiled94114953_ceiled
chained133812693chained
chaired134211243chaired
claimed12298833claimed
coaled95022713coa_led
coiled95123943_coiled
craaled10339423craaled
cradled113410813cradled
crawled133710403crawled
deaired9411533deaired
defiled124013103defiled
derailed102410403derailed
detailed10319873detailed
deviled124112183deviled
dialed84716453dia_led
dialled9510133dialled
doiled84817293_doiled
drained93713253drained
drawled12368343drawled
eagled82914043_eagled
enabled102510633enabled
ensiled82611433ensiled
entailed989523entailed
evaded1137063eva_ded
eviler94811893ev_iler
evited104013143ev_ited
exiled144712463_exiled
fabled124216383_fabled
faired105915773_faired
fantailed1345563fantailed
filed95331903__filed
foaled104515963foa_led
foiled104618403_foiled
frailer10319943frailer
gabled105518453_gabled
gained84617463_gained
gaited84416923_gaited
galled84622863_galled
gaoled84814503_gaoled
gaveled12399133gav_eled
gavelled13387363gavelled
glaired9387753glaired
glaived12375973glaived
gnarled9287723gnarled
goaled85014363goa_led
grained93814273grained
guiled84315383_guiled
hailer94720343_hailer
haired105117173_haired
haled95335823_ha_led
hauled104415213_hauled
healed105121443hea_led
heiled104415613_heiled
ivied94710523iv_i_ed
jailer134316683_jailer
kraaled12254983kraaled
kvelled15276063kvelled
ladled85013483_ladled
laired75216813_laired
lalled74218753_lalled
lavalier1146043lavalier
liaised837113liaised
macled116718113_macled
maile75232223_maile_
mailer84724183_mailer
mailes84329113_mailes
maimed114812663_maimed
malled94626113_malled
manacled1336453manacled
marled95523163_marled
mauled94817823_mauled
measled10339303measled
miauled1036663miauled
moiled94318863_moiled
nailer64119363_nailer
naled65525053_na_led
navaid1037653navai__d
oiled64429473__oiled
paiked135113433_paiked
pained95622853_pained
paired95017523_paired
paled85538723_pa_led
palled94625163_palled
pantiled113111593pantiled
parled94626293_parled
pealed95322813pea_led
pearled10411553pearled
periled10316323periled
piled85232993__piled
plaided11409643plaided
plained103812233plained
plaited103713893plaited
praised104214813praised
prevailed1536043prevailed
raided85017703_raided
railer64524933_railer
rained75024603_rained
raised76120333_raised
rattailed1084213rattailed
ravaged1236493rava_ged
raveled114113633rav_eled
ravelled12419783ravelled
ravined115411823rav_ined
refiled114318653refiled
remailed112411403remailed
renailed92512803renailed
reoiled84316853reoiled
resailed93613063resailed
resiled84621983resiled
retailed94113963retailed
retiled84420513retiled
reviled114417923reviled
riled65833253__riled
rivaled1138933riva_led
rivalled1236093rivalled
roiled74320053_roiled
sailer63526103_sailer
sained75424243_sained
savable121711863savable_
savaged1236993sava_ged
savvied1433803savvi_ed
scaled94822443sca_led
sealed74328363sea_led
shaled105023953sha_led
shauled1148793shauled
shawled1437773shawled
smiled93716433_smiled
snarled83612363snarled
soiled73822473_soiled
spalled103113133spalled
speiled104412123speiled
spiled94621993_spiled
spoiled104811353spoiled
stabled103514953stabled
stained84215343stained
staled74728103sta_led
stalled83515693stalled
stapled103613703stapled
tabled94020043_tabled
tailer63823733_tailer
teazled17326833teazled
tiled64832943__tiled
toiled74420323_toiled
traiked123310453traiked
trailer73015393trailer
trained84117203trained
trawled113411523trawled
unaided92414603unaided
unaimed102812493unaimed
unaired82916013unaired
unhailed12219963unhailed
unmailed11229763unmailed
unnailed9229443unnailed
unoiled82415483unoiled
unpiled102312743unpiled
unveiled1298163unveiled
uppiled12216593uppiled
vagile10310543vagile_
vail75432553_vail__
vails85825933_vail_s
vainer93714573_vainer
vale74937343_va_le_
vales85434263_va_les
valet84337873_va_let
valid94618393_va_lid
valley124311603_valley
valued104011153_valued
valved136711043_valved
vamped144211013_vamped
vaned94622423_va_ned
vanned104614483_vanned
varied104817863_varied
varlet9423503_varlet
varved134110603_varved
vatted104214733_vatted
vaulted11307193_vaulted
vealed103916323_vealed
veiler93814353_veiler
veined104413913_veined
vialled1156843vialled
viced115118183_v_iced
vied86328633_v_i_ed
vile76139803_v_ile_
viler86324163_v_iler
vined95626153_v_ined
vised95518763_v_ised
voiced123910113_voiced
voided114011133_voided
voile84719723_voile_
voiles94616443_voiles
voled95323723_v_oled
waifed134011033_waifed
wailer93720323_wailer
waired106015833_waired
waited103819773_waited
waived134511283_waived
waled94330993_wa_led
walled104021293_walled
wassailed1343153wassailed
wauled104713963_wauled
wawled133811703_wawled
whaled134612033wha_led
whiled134514133_whiled
wiled95231553__wiled
yawled13459983_yawled

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.440406115.9
2DLD Change Limit1340273445.84322938.0
3Display Results3443440.1262730.2
 (SQL Overall)1786913446.40927881.3
 
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.