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

277 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
predial10381541(None) 
praedial1178761praedial
redial74923111_redial
uredial82910481uredial
credal9311672cred_al
gremial1039152gremial
medial93819862_medial
pedal86022502p_ed_al
penial84120892p_enial
peridial11411922peridial
prandial1149642prandial
preanal9310712preanal
preaxial1746972preaxial
prebill1138812prebill
predict12315332predict
predive13511082predive
predrill1145932predrill
prefixal2044542prefixal
preludial1244872preludial
premeal11310522premeal
preoral9312672preoral
prepill1147592prepill
presidial1247222presidial
pretrial10511982pretrial
prevail1238242prevail
prodigal1246002prodigal
proemial1249182proemial
pyrexial20234972pyrexial
radial74020392_radial
redia65524482_redia_
rediae74221992_rediae
redials84416892_redials
redias74523612_redias
retial64724992_retial
uredia73610062uredia_
acedia9310403acedia_
acedias1039783acedias
aecial84817313_aecial
aerial64625713_aerial
alodial899953alodial
areal55928743are__al
arterial8313653arterial
audial7312993_audial
biradial1167713biradial
breccial1444693breccial
bridal9511453brid_al
cordial10312953cordial
cranial92114683cranial
credible1346023credible
credibly1644713credibly
credit9315193credi_t
credits1039983credits
creedal1037093creedal
crestal9312133crestal
crucial1157893crucial
daedal849083daed_al
dedal75719023_ded_al
denial74720513_denial
dial55935073___dial
dreidel934473dreidel
dreidl835233dre_idl
fecial114714623_fecial
ferial94621253_ferial
fetial95716193_fetial
genial74917613_genial
gradual936943gradual
gremials1136143gremials
hernial10310433hernial
irenical1048563irenical
khedival1941993khedival
medal86221333_med_al
media84721713_media_
mediad104313713_mediad
mediae94217413_mediae
medials103914743_medials
median94117543_median
medias93620783_medias
medical12312513_medical
menial84223033_menial
mesial84818083_mesial
misdial1039643misdial
oedipal1045173_oedipal
ordeal779253or_deal
ordinal838643or_dinal
pallial92911263pallial
paradisal1246883paradisal
parental10310953parental
parodical1447563parodical
partial92616263partial
peal68648103p_e__al
pedalo93811153p_ed_alo
pedals94316033p_ed_als
pedicab1446693p_edicab
pedicel1237813p_edicel
pedicle1238973p_edicle
pedipalp1242513p_edipalp
pedlar93311273p_edlar
pedocal1237893p_edocal
penal75228373p_e_nal
perdie94718513perdi_e
pereia85217983pereia_
perennial1147233perennial
peridia10312373peridia_
peril75425953p_eri_l
permian112612283permian
peroral9314793peroral
perusal939193perusal
petal76526893p_e_tal
phial10313203p__hial
pial65636713p___ial
pleiad947833ple_iad
pleonal937243pleonal
pleural956673pleural
plexal1536843ple_xal
pluvial1245433pluvial
podia8415283p_odia_
poetical12311533poetical
prebasal1244723prebasal
prebid113512853prebi_d
prebids12399893prebids
prebills1237303prebills
prebind123810653prebind
preboil1148963preboil
precaval1544723precaval
prechill1546193prechill
precipe133012123precipe
precis103416713preci_s
precise113518173precise
precocial1547513precocial
precoital1347273precoital
precool1139013precool
predate10616893predate
predawn1335353predawn
predeath1447003predeath
predella1145393predella
predicable1747193predicable
predicant1449403predicant
predicate14411783predicate
predicts1339633predicts
predraft1447593predraft
predried12309573predried
predries112714393predries
predrills1244473predrills
predry1237873pred_ry
predusk1443773predusk
preedit10512463preedi_t
preedits1168773preedits
preeing103817673preeing
prefab1336243pre_fab
prefile123413183prefile
prefire124012813prefire
prefix18356853prefi_x
preheat12413893preheat
prelaw1139103pre_law
prelegal1145053prelegal
prelife1279953prelife
prelim10311433preli_m
prelims1139833prelims
preload1049813preload
preman104117453pre_man
premedical1745313premedical
premie103617993premi_e
premier113515633premier
premies113823073premies
premise113818553premise
premiss113513823premiss
premium13310363premium
premix173710333premi_x
premixt183510663premixt
premoral1249713premoral
prenatal1048373prenatal
prepaid12310133prepaid
prepay13310313pre_pay
preplan1149953preplan
prepupal1164263prepupal
preputial1345673preputial
prequel1836343prequel
prerenal1049083prerenal
preriot9316413preriot
presa74319043pre_sa_
presale9416353pre_sale
presell939303presell
preside10715623preside
presidia1147283presidia_
presift12312233presift
presignal12105553presignal
presoak1348463presoak
pretax152310193pre_tax
pretell938243pretell
pretorial11512663pretorial
pretrials1158153pretrials
pretzel1835143pretzel
prevails1337683prevails
previable1647543previable
preview1536473preview
previse123713803previse
prewar114712583pre_war
prewire124311143prewire
prewrap14104973prewrap
prexies163415013prexies
preying133114563preying
priding113317543priding
priedieu1153983priedieu
prill74117943pr__ill
primal104014623pr_imal
prodigals1344233prodigals
prodigy1435573prodigy
proviral1346493proviral
proximal1945183proximal
prudish1376563prudish
pyemia1337553pyemia_
pyemias1436803pyemias
pygidial1543303pygidial
pyrexia19225463pyrexia_
pyrexias20225003pyrexias
racial83419243_racial
radiale83813523_radiale
radials83614643_radials
radian74117273_radian
radical103312793_radical
real45750293_re__al
rebill84713253_rebill
recital9412173_recital
recoal84117983_recoal
rectal84418143_rectal
redan66125013_red_an
redbay1238333_redbay
redcap1158493_redcap
redear73515173_redear
redialed10310793_redialed
redid74922393_redi_d
reding83825563_reding
redip87816963_redi_p
redips93713843_redips
redipt94116743_redipt
redraw10269853_redraw
redrill857893_redrill
redtail858713_redtail
refill94514053_refill
regal65023793_re_gal
reginal84814293_reginal
regnal74812933_regnal
remail85017123_remail
remedial1147553remedial
renail65020763_renail
renal55929513_re_nal
rental63922033_rental
reoil55321183_reoi_l
repeal84718293_repeal
resail64418733_resail
reseal64819653_reseal
retail65522073_retail
retia55326113_retia_
retinal75318353_retinal
retral64419743_retral
retrial7615553_retrial
reveal94115063_reveal
revisal1038273_revisal
revival1337033_revival
rial45938103_r__ial
serial64625863_serial
special11310303special
splenial1047183splenial
sundial859863sundial
telial65815363_telial
tertial7313863tertial
trenail7410813trenail
trial54926353tr__ial
trivial1038713trivial
ureal56722683ure__al
uredinial1043913uredinial
uredium1076693uredium
uremia82910893uremia_
uremias9249513uremias
urial54823023ur__ial
venial94218283_venial
xenial133414903_xenial

Search took 9 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.420425454.8
2DLD Change Limit1340272777.65617506.1
3Display Results2772770.0932978.5
 (SQL Overall)1786912778.16921874.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.