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

225 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
preoral931267(None) 
peroral9314791peroral
premoral1249711premoral
pleonal937242pleonal
pleural956672pleural
preanal9310712preanal
predial103815412predial
premeal11310522premeal
pretorial11512652pretorial
pretrial10511982pretrial
prewrap14104972prewrap
retral64419742_retral
aboral8314373_aboral
amoral8314633_amoral
apteral9311523apte_ral
arboreal1045633arboreal
areal55928743are__al
areola6813673areola_
areolae7811733areolae
areolar779223areolar
areolas71013873areolas
armorial1049453armorial
auroral7310473auroral
boral75831703__boral
bromal10313653br_omal
caporal11410943caporal
ceorl7410923_ceor_l
cerebral1266183cerebral
chloral12169983chloral
choral115118493_choral
coral76033453__coral
corporal1248513corporal
credal9311673cre_dal
creedal1037093creedal
creosol946053creosol
crestal9312133crestal
crural8610633cr_ural
ephoral1248403ephoral
femoral1238723femoral
feral85424653_fe_ral
floral94313813_floral
gooral7310463_gooral
goral65125753__goral
gremial1039153gremial
horal86328683__horal
humoral1237983humoral
immoral1146783immoral
litoral7610763litoral
loral55927823__loral
mayoral1237693mayoral
moral75533433__moral
neural6311993_neural
nonoral7313603nonoral
oral47638123___oral
pakora1247283pakora_
pakoras1337473pakoras
papyral1445773papyral
pareira937553pareira_
pareiras1038193pareiras
parental10310953parental
parfocal1565393parfocal
parral85517543p_arral
pastoral10310483pastoral
peal68648103p_e__al
pearl75324463p_ear_l
pectoral121210503pectoral
pedal86022503p_e_dal
pedocal1237893pedocal
penal75228373p_e_nal
penial84120893p_enial
peril75425953p_e_ril
peroneal1049173peroneal
perorally1448223perorally
perorate10417923perorate
personal102311573personal
perusal939193perusal
petal76526893p_e_tal
petrale9312623p_etrale
petrel83111533p_etrel
petrol82714063p_etrol
peytral1287503peytral
phonal11310383p_honal
phratral1344373phratral
pivotal1245433pivotal
pleura837533pleura_
pleurae945863pleurae
pleuras937413pleuras
plexal1536843ple_xal
plural839823p_lural
portal84218463p__ortal
postoral10311723postoral
praedial1178763praedial
praetorial1257093praetorial
prearm104512353prear_m
prearms11369173prearms
preaxial1746973preaxial
prebasal1244723prebasal
prebill1138803prebill
preboard1338263preboard
preboil1148953preboil
precaval1544723precaval
precocial1547503precocial
precoital1347273precoital
precool1139013precool
precrash1544823precrash
predraft1447593predraft
predrill1145933predrill
predry1237873predr_y
prefab1336243pre_fab
prefixal2044543prefixal
preform1439623prefor_m
preformat1646363preformat
preforms1537413preforms
prefrank1764233prefrank
preheat12413893preheat
prelaw1139103pre_law
prelegal1145053prelegal
preload1049813preload
preman104117453pre_man
premolar1246633premolar
premorse1237553premorse
prenatal1048373prenatal
preop94715873preo__p
preops104911943preo_ps
preordain12124493preordain
preorder1136463preorder
prepare111913623prepare
prepay13310313pre_pay
prepill1147583prepill
preplan1149953preplan
prepreg12165963prepreg
prepupal1164263prepupal
prequel1836343prequel
prerace11414123pre_race
prerenal1049083prerenal
prerock1536723prerock
presa74319043pre_sa_
presale9416353pre_sale
presell939303presell
presoak1348453presoak
presort95219543presor_t
presorts105311683presorts
pretax152310193pre_tax
pretell938243pretell
pretor8315753pretor__
pretorian11511553pretorian
pretors9316813pretor_s
pretrain10310923pretrain
pretravel1444123pretravel
pretreat10311923pretreat
pretrials1158143pretrials
pretrim11310783pretrim
pretzel1835143pretzel
prevail1238243prevail
preverbal1643883preverbal
prewar114712583pre_war
prewarm14479613prewarm
prewarn124410153prewarn
prework164210913prewor_k
preworks17599013preworks
preworn124711223prewor_n
prewraps15114053prewraps
primal104014623pr_imal
prior74316173prior__
priorate10411733priorate
priorly12335763priorly
priors83914483prior_s
priory114110263prior_y
proa66229963pr_o_a_
proas75028803pr_o_as
procural1246923procural
proemial1249183proemial
program12311693program
prolan8414693pr_olan
propel103714063pr_opel
proposal1247743proposal
propyl13358183pr_opyl
prorate9418733pr_orate
prosomal1248543prosomal
protyl11308213pr_otyl
proviral1346493proviral
prowar114110943pr_owar
prowl105615123pr_o_wl
puberal1147773puberal
pyrexial20234973pyrexial
real45750293_re__al
recoal84117983_recoal
rectal84418143_rectal
redial74923113_redial
redraw10269853_redraw
regal65023793_re_gal
regnal74812933_regnal
remora8414593_remora_
remoras9314073_remoras
removal1236733_removal
renal55929513_re_nal
rental63922033_rental
reoil55321183_reo_il
repeal84718293_repeal
reposal939113_reposal
reran57329103_re_ran
reroll6412683_reroll
reseal64819653_reseal
restoral8810983_restoral
retial64724993_retial
retotal739843_retotal
retrial7615553_retrial
reveal94115063_reveal
rewrap11127533_rewrap
royal85014703_r_oyal
rural55821173_r_ural
seral56336383_se_ral
serosal7311153serosal
sororal7310653sororal
spheral1238423sphe_ral
sporal82915453_sporal
suboral92011993suboral
sudoral8148543sudoral
tumoral938133tumoral
unmoral948693unmoral
uprootal1043453uprootal
ureal56722683ure__al
uredial82910483uredial
ureteral856233ureteral
urethral1154633urethral

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.486367677.0
2DLD Change Limit1340272256.11021935.7
3Display Results2252250.0762960.5
 (SQL Overall)1786912256.67226782.2
 
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.