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

193 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
preanal931071(None) 
penal75228372p_e_nal
pleonal937242pleonal
preaxial1746972preaxial
prebasal1244722prebasal
precaval1544722precaval
predial103815412predial
premeal11310512premeal
prenatal1048372prenatal
preoral9312672preoral
prerenal1049082prerenal
regnal74812932_regnal
renal55929502_re_nal
adrenal838263adre_nal
anal48037523___anal
arcana8912583arcana_
areal55928733are__al
areaway1335913areaway
arena55323813are_na_
arenas65021993are_nas
arrayal1055843arrayal
arsenal739383arsenal
banal75925993__banal
canal75428043__canal
ceramal1138843ceramal
craal74117753cr_a_al
cranial92114683cr_anial
credal9311673cre_dal
creedal1037093creedal
crenel84213063cre_nel
crestal9312133crestal
decanal1038113decanal
eternal72910893eternal
fraena938063fraena_
frena85915273fre_na_
fresnel1035893fresnel
geranial949283geranial
graal64316503gr_a_al
grana65722093gr_ana_
gremial1039153gremial
kraal94511823kr_a_al
lienal63912783lie_nal
meatal84114733_meatal
ordinal838633ordinal
organa789213organa_
paean77222723paean__
paeans85118263paean_s
paginal10269493paginal
palatal9310153palatal
panel76023623p__anel
papal95820673p__apal
parental10310943parental
paternal1038333paternal
peal68648103p_e__al
pean66147173p_ean__
peans75437643p_ean_s
peanut8318183p_eanut
pearl75324463p_ea_rl
pedal86022503p_e_dal
penial84120893p_enial
penna74520203p_enna_
pennae84314033p_ennae
perennial1147233perennial
perineal1049183perineal
peroneal1049163peroneal
peroral9314793peroral
personal102311573personal
perusal939193perusal
petal76526893p_e_tal
petnap1037423p_etnap
phenol1149253phe_nol
phenyl1435323phe_nyl
phonal11310383p_honal
phrasal1246163phrasal
pinnal84814273p_innal
pirana8713263pirana_
piranas9912603piranas
plagal948573p_lagal
planar84212713p_lanar
plena75816393ple_na_
pleural956673pleural
plexal1536833ple_xal
postanal1048053postanal
praam94815613pr_a_am
praedial1178763praedial
prajna1535073prajna_
prajnas1635453prajnas
prance104318573pr_ance
prandial1149643pr_andial
prang84820323pr_an_g
prangs94816233pr_angs
prank115019453pr_an_k
pranks124814723pr_anks
preach133613923prea_ch
preachy17307313preachy
preact103220393prea_ct
preacts113211363preacts
preadapt1346863preadapt
preadult1146973preadult
preaged11612333preaged
preamble1436383preamble
preamp1238993prea_mp
preamps1336613preamps
preapply1443293preapply
prearm104512343prea_rm
prearms11369173prearms
preaver121011613preaver
prebendal1444003prebendal
prebill1138803prebill
preboil1148953preboil
precancel1546203precancel
precaudal1443413precaudal
precava1445093precava_
precavae1544813precavae
precool1139013precool
preen75925053preen__
preenact12410183preenact
preened103214983preened
preener93114833preener
preens85020113preen_s
prefab1336243pre_fab
prefixal2044543prefixal
pregnable1456693pregnable
pregnant1149883pregnant
prehandle1544533prehandle
preheat12413893preheat
prelaw1139103pre_law
prelegal1145043prelegal
preload1049813preload
preman104117453pre_man
premoral1249713premoral
prename11412643prename
prepay13310313pre_pay
prepill1147583prepill
preplan1149953preplan
prepupal1164263prepupal
prequel1836343prequel
presa74319043pre_sa_
presale9416353pre_sale
presell939293presell
presignal12105553presignal
presoak1348453presoak
pretax152310193pre_tax
pretell938233pretell
pretrial10511983pretrial
pretzel1835143pretzel
prevail1238243prevail
prewar114712573pre_war
prewrap14104973prewrap
primal104014623pr_imal
primatal1247133primatal
proemial1249183proemial
purana8712933purana_
puranas9712643puranas
pyrexial20234963pyrexial
ramal74622243_r_amal
ratal55025113_r_atal
real45750293_re__al
reata54225393_reata_
reatas64021013_reatas
reavail1035643_reavail
recoal84117973_recoal
rectal84418133_rectal
redial74923113_redial
regal65023793_re_gal
reginal84814293_reginal
regna64614813_regna_
renail65020763_renail
rental63922023_rental
repanel939963_repanel
repeal84718283_repeal
reseal64819643_reseal
retial64724993_retial
retinal75318353_retinal
retral64419743_retral
reveal94115053_reveal
rhinal9510193_rhinal
ruana5312423_ruana_
ruanas6311263_ruanas
sternal73411913sternal
tetanal738023tetanal
thenal92712423the_nal
treenail846123treenail
trenail7410813trenail
trinal6516963tr_inal
upheaval1641583upheaval
uranyl936293ur_anyl
ureal56722683ure__al
uredial82910483uredial
urinal6614123ur_inal
veinal93812963_veinal
venal85523213_ve_nal
vernal93514213_vernal

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.1431249587.4
2DLD Change Limit1340271937.11018850.5
3Display Results1931930.0762539.5
 (SQL Overall)1786911937.32924381.4
 
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.