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

520 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
derails8421639(None) 
derail74218811derail_
details84214041details
drails74716951d_rails
serails73318361serails
aerials74017552aerials
bedrails1136292bedrails
bewails1277552bewails
brails84621292_brails
deairs74013782de_airs
deals65435342de_a_ls
dearies83526272dearies
decals93717712deca_ls
decrials1137132decrials
deils65722862de__ils
denials84114132denials
dentils84115582dentils
deraign936572deraign
deraigns1034882deraigns
derailed102410402derailed
derates84028892derates
derats74625062dera_ts
derays105514252dera_ys
derbies103016052derbies
dermis94717162dermi_s
derries83124622derries
derris73615272derri_s
detail74516432detail_
detains83716092detains
detrains9411762detrains
devils104412812de_vils
drail65020972d_rail_
drains73719402d_rains
drawls105511392d_rawls
emails84412342_emails
ervils948772_ervils
ferals94216642fera_ls
frails93716472_frails
gerbils1037302gerbils
grails77518782_grails
jezails2334162jezails
perils84121852per_ils
rails55937402__rails
remails94714562remails
renails74917262renails
resails74616742resails
retails74718972retails
serail64222672serail_
serais64326132serai_s
serials73919752serials
tenails73713922tenails
terais64023512terai_s
trails64622512_trails
aerates74627493aerates
aerial64625713aerial_
aeries64737783aer_ies
aerily93017013aer_ily
agnails837003agnails
ails45654713___ails
airmails1045273airmails
argils75213623_argils
arils58732203_ar_ils
assails769093assails
avails939693_avails
bails75933523__bails
becrawls1543623becrawls
bedrail1037253bedrail_
befalls12349123befalls
begalls10319163begalls
berakes134815773berakes
berates94126873berates
berlins93216013berlins
berries94423553berries
beryls11107883ber_yls
bewail1189583bewail_
bezils1711310603be_zils
borals86721913bora_ls
braids95015693_braids
brail75525553_brail_
brains85125473_brains
brasils9410973_brasils
brawls115214333_brawls
brazils1867753_brazils
broils84114173_broils
burials93612083burials
camails11311753camails
ceils75019403ce__ils
ceramals1246513ceramals
ceramics1446803ceramics
cerates95428253cerates
ceratins102818733ceratins
cercis104614493cerci_s
cereals9313173cereals
cerias83321983cer_ias
chervils1644553chervils
corals85325143cora_ls
craals84113303_craals
crawls114712083_crawls
curtails10318243curtails
dahls95012283d__ahls
daily95922333d__aily
dais57040703d__ai_s
dals57145123d__a_ls
darbies104216983darbies
darics94314113dar_ics
darkies124015753darkies
darnels83710433darnels
deadly113811473de_adly
deads75726913de_a_ds
deafly13389123de_afly
deair65817193de_ai_r
deal56347413de_a_l_
dealt65234283de_a_lt
deans66131393de_a_ns
dearie73319813deari_e
dearly104615323de_arly
dears65736883de_a_rs
dearths11498843dearths
deasil71110983deasil_
deaths105914443de_aths
deaves105319533de_aves
debacle1237443debacle
debacles1335723debacles
debags104211063deba_gs
debarks14388493debarks
debars94218043deba_rs
debases103814133debases
debates103718533debates
debits94214503de_bits
debris93311493debri_s
decades113615513decades
decafs124010883deca_fs
decal85523233deca_l_
decamps1435643decamps
decanes103118913decanes
decants103514443decants
decares102818533decares
decays124612913deca_ys
deceits102810883deceits
decile94619213de_cile
deciles104417723de_ciles
deckels14367363deckels
declaims1345823declaims
decrial10310323decrial_
decries103319803decries
dedal75719023deda_l_
dedans85915073deda_ns
defaces133213403defaces
defames132812253defames
defangs1235363defangs
defats105114553defa_ts
default1147893default
defaults1243333defaults
defies104624053de_fies
defile105216663de_file
defiles114016843de_files
defis96717503de_fi_s
defrags1236193defra_gs
defrauds1343243defrauds
defrayals1642283defrayals
defrays1436113defra_ys
defuels11296983defuels
degames113312623degames
degamis11268443degamis
degas75119163dega__s
degases93413103degases
degauss933923degauss
degrades11269923degrades
deifies113317453deifies
deil56231623de__il_
deities82621923deities
deixis1437243deixi_s
dekares122710873dekares
delaine8314793delaine
delaines9312963delaines
delates83526283delates
delays104014053dela_ys
delis64928543de_li_s
dellies83622213dellies
dells66630943de__lls
dels56745473de___ls
demands114311413demands
demarks14339233demarks
demasts1089223demasts
demies94825803de_mies
demits94918073de_mits
denarius948813denarius
denars74621433dena_rs
denial74720513denial_
denies74729643de_nies
denims95214323de_nims
dentals83915393dentals
dentil74017883dentil_
dentins83419223dentins
deorbits1144613deorbits
depaint10314593depaint
depaints1136643depaints
departs104310683departs
depraves1436873depraves
derailing112011313derailing
derange939813derange
deranges1039973deranges
derat65044083dera__t
derate74531233dera_te
derated93623503derated
derating103222283derating
deray95024183dera__y
deride84420033der_ide
derides93420853derides
derive103817043der_ive
derives114017813derives
dermal93614343dermal_
dermas94116813der_mas
dermic114511913dermi_c
dermises112512023dermises
dermoids1246163dermoids
derms85022893der__ms
dernier83011943dernier
derrick1435803derrick
derricks1544433derricks
derrises93012783derrises
dervish1436983dervish
desalt7518313desa_lt
desalts839573desalts
desands94810163desands
desmids1166603desmids
despairs1144943despairs
despoils1145623despoils
destains9311813destains
detailed10319873detailed
detailer9268673detailer
detailers10257253detailers
detain74617383detai_n
detracts11138833detracts
detrain8412253detrai_n
devas96218883deva__s
deveins1138813deveins
devels104313903de_vels
devil94714733de_vil_
devoirs1175783devoirs
dewans105215143dewa_ns
dewars105117073dewa_rs
dewaxes18297843dewaxes
dewfalls1543073dewfalls
dewily1338343de_wily
dewools1145593dewools
dexies145018343de_xies
dhals95415443d_ha_ls
dials64925343d_ia_ls
diaries83321953diaries
dirams94413703dira_ms
dirls64720503dir__ls
dirndls933893dirndls
dirties83119383dirties
dirtily1138583dirtily
distils83015803distils
domains10510873domains
doornails1043623doornails
dorados938203dorados
dories75232363dor_ies
dormins10311273dormins
dorsals84110853dorsals
dorsels84412583dorsels
dossils8669773dossils
dovetails1343813dovetails
drably123511613d_rably
drabs85119673d_ra_bs
draffs13617903d_raffs
drafts105012533d_rafts
drags75521113d_ra_gs
drain65222893d_rai_n
drakes114715863d_rakes
dramas95814663d_ramas
drams86025833d_ra_ms
drapes95419653d_rapes
drats66628373d_ra_ts
drawl95516013d_rawl_
drawly134910723d_rawly
draws95119373d_ra_ws
drays95819773d_ra_ys
dreads84115023drea_ds
dreamily1435143dreamily
dreams94513983drea_ms
drearies92313413drearies
drearily1236083drearily
drears74614253drea_rs
dreidls934053dreidls
dribs85115063d_r_ibs
dries64733673d_r_ies
drill64718263d_r_ill
drills74414203d_rills
drily95816523d_r_ily
drips85417233d_r_ips
droids84712583d_roids
droits74314313d_roits
drolls75312393d_rolls
drools74412813d_rools
druids8368093d_ruids
duals65620083d_ua_ls
durable102312723durable
durables11237013durables
durably13229053durably
dural64923893dura_l_
duras65727733dura__s
durians839573durians
durries83817353durries
earls56127513_e_arls
eerily92913563eer_ily
elains64919853_elains
email74715103_email_
engrails945383engrails
entails7912823entails
entrails8310163entrails
eras45441503_era__s
erases64425403_erases
ervil8310303_ervil_
evils84114263_e_vils
fails85631483__fails
fecials123510333fecials
federals1247303federa_ls
feral85424653fera_l_
ferial94621253ferial_
ferias95020393fer_ias
ferlies103216693ferlies
fermis114313503fermi_s
ferrels10248623ferrels
ferries103521083ferries
fertile10311733fertile
fetials103711743fetials
flails94313003_flails
frail85220213_frail_
frazils1956123_frazils
gerahs1039413gera_hs
geranials1045913geranials
geraniols1044743geraniols
gerbil938343gerbil_
gorals76917653gora_ls
graals74112913_graals
grail64622873_grail_
grains74223093_grains
hails85231643__hails
heals85733463he_a_ls
heils85222193he__ils
herald10311343hera_ld
heralds1137713heralds
herbals122710613herbals
herdics13249523herdics
herls85226433her__ls
hermits12312143hermits
hernias10310773hernias
heroics122912003heroics
heroins103518013heroins
herries104025073herries
ideals75012503ide_a_ls
jails125422943__jails
jerids142810943jer_ids
jerkies183411583jerkies
jerkily2134623jerkily
jerkins18358253jerkins
jerrids15277743jerrids
jerries143817513jerries
jezail2234643jezail_
kails95525213__kails
keramics1644823keramics
keratins122313483keratins
kermis124012393kermi_s
kernels11417953kernels
kerrias11289513kerrias
kerries113317913kerries
kevils13358333ke_vils
kraals10378433_kraals
kraits104912203_kraits
legals73412733lega_ls
lentils73912973lentils
mails76037783__mails
meals75933383me_a_ls
medals94218063meda_ls
medials103914743medials
menials94015693menials
mercies113817563mercies
merits8320873mer_its
merlins93015813merlins
merls77423903mer__ls
mermaids1355753mermaids
merrily1238633merrily
metals84520893meta_ls
morals85324643mora_ls
murals84016763mura_ls
nails55730403__nails
nereids838743nereids
nereis6315343nerei_s
nerolis71012773nerolis
nerols6914883ner_ols
nervily1336863nervily
ooralis7312553ooralis
orals55826483_ora_ls
overalls11410393overalls
oxtails1436383oxtails
pails75833063__pails
peals75235493pe_a_ls
pearls84715393pe_arls
pedals94316033peda_ls
pencils113011773pencils
pensils92811593pensils
peracids13310073peracids
peril75425953per_il_
peris75537073per_i_s
perkily1637813perkily
permits11314003permits
perries93226603perries
pertains102113423pertains
petals84719813peta_ls
prevails1337663prevails
quails153412643_quails
raias54631123__raias
raids65827513__raids
rail46147763__rail_
rains55140233__rains
rais45252623__rai_s
reals55038653re_a_ls
reavails1134853reavails
rebaits9312573rebaits
reboils94111723reboils
recalls92613623recalls
recoils93814873recoils
redials84416883redials
redtails968003redtails
refalls103312243refalls
refrains1139593refrains
regains84316583regains
remail85017123remail_
remains94117913remains
renail65020763renail_
reoils64516873re_oils
repairs9319973repairs
reracks132310533reracks
reraise7316313reraise
reraises8415643reraises
rerigs74014793rer_igs
rerolls739943rerolls
resail64418733resail_
retail65522073retail_
retains74522253retains
retrains8314533retrains
retrials8510823retrials
rials55026673__rials
roils54826793__roils
ruderals946073rudera_ls
sails55738103__sails
scrawls12177283scrawls
seals54839703se_a_ls
sepals85217383sepa_ls
seracs84418573sera_cs
serai56830163serai__
seral56336383sera_l_
serapes95218103serapes
seraphs12408093seraphs
sereins73716123sereins
serial64625863serial_
series64540973ser_ies
serifs94017053ser_ifs
serins64029673ser_ins
serries73925353serries
servals103410753servals
servile10310643servile
snails64816653_snails
spails84817823_spails
sprains93013593sprains
sprawls12176373sprawls
strains74218153strains
straits74916323straits
swails94913123_swails
tails55634193__tails
teals56234133te_a_ls
tearily10311153tearily
tenail64516113tenail_
tepals85415043tepa_ls
terai53525483terai__
terbias9310743terbias
tercels94110363tercels
terrains8410323terrains
terries73425633terries
territs72714503territs
tertials8510073tertials
thralls10299043thralls
toenails847213toenails
traiks104013713_traiks
trail55126773_trail_
trains64725343_trains
traits65121983_traits
trawls94412393_trawls
trenails869843trenails
trials64319883_trials
unnails738223unnails
uracils939373_uracils
urials64415193_urials
vails85825933__vails
veals84926193ve_a_ls
veils84918803ve__ils
ventails1139823ventails
verbals121910743verbals
verbids13259203verbids
verbile1249863verbile
verbiles1338923verbiles
verdins112812333verdins
verily122616053ver_ily
vermeils1374813vermeils
vermis114214963vermi_s
vervains1435293vervains
vexils1647173ve_xils
wails86631483__wails
weals85428743we_a_ls
wearies103020223wearies
wearily1338783wearily
weevils1384683weevils
wergild1234043wergild
wergilds1342653wergilds
wormils1236733wormils
zeals145320853ze_a_ls
zorils153810883zor_ils

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.410435831.7
2DLD Change Limit1340275206.71619956.4
3Display Results5205200.1862795.7
 (SQL Overall)1786915207.31224438.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.