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

240 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
paginal1026949(None) 
vaginal11288401vaginal
agonal7410052_agonal
anginal8310162anginal
basinal9310032basinal
carinal94318242carinal
imaginal1144902imaginal
laminal94113632laminal
magical1239782magical
marginal1137612marginal
matinal9312602matinal
paginate114012442paginate
paging104020402pagin_g
pagings114411062pagings
patina86022192patina_
patinae95414402patinae
patinas96318522patinas
reginal84814292reginal
vagina102710932vagina_
vaginae11377682vaginae
vaginas11298812vaginas
acinar8310483_acinar
actinal9312293actinal
adagial946373adagi_al
affinal1336443affinal
agin56132713_agin__
aging77026353_agin_g
agings86312673_agings
agita6315423_agita_
agitas7310593_agitas
agnail739533_ag_nail
albinal937813albinal
anal48037523_a__nal
angina7413133angina_
anginas8310953anginas
animal85016253_animal
annal56520763_a_nnal
apical10913903_apical
apsidal1046703apsidal
atonal6514023_atonal
axial124515193_axi_al
axonal1347653_axonal
azonal1568273_azonal
banal75925993ba__nal
binal75323823__binal
caging105321023cagin_g
canal75428043ca__nal
capital112311523capital
cardinal1139573cardinal
carina84325333carina_
carinae94318593carinae
carinas93622413carinas
carnal83919213ca_rnal
clinal8311553_clinal
datival1135583datival
diagonal1095653diagonal
digital937063digital
encinal949243encinal
facial113615633faci_al
fagin9216573fagin__
fagins10513863fagin_s
farina94618233farina_
farinas103215243farinas
faunal94711593fa_unal
final83922033__final
gaging94718403gagin_g
gavial10310083gavi_al
geminal10109913geminal
gingal81010153__gingal
inguinal945603inguinal
jarina134014063jarina_
jarinas143712193jarinas
labial84714343labi_al
lacunal9136553lacunal
lagoonal943093lagoonal
laguna7127223laguna_
lagunas8156823lagunas
laical8312323la_ical
lamina84920443lamina_
laminae93512973laminae
laminals10339313laminals
laminar93810283laminar
laminas93615873laminas
lanital7310913lanital
latina65621143latina_
latinas74416463latinas
liminal93810673liminal
logical1038513logical
luminal93711003luminal
magian9312833magi_an
magians10310753magians
marginals1246013marginals
marina84623413marina_
marinas93519393marinas
marital92314183marital
maximal18347093maximal
nadiral836343nadiral
nagana748943nagana_
naganas847983naganas
narial6317953nari_al
nasial6413283nasi_al
national8311533national
nominal92712373nominal
ogival1035873_ogival
ordinal838643ordinal
original956793original
pacing114522753pacin_g
padnag1036073pa_dnag
pagan86121163pag__an
pagans95717923pagan_s
pageant10312783pageant
pageful1346353pageful
paginated13309463paginated
paginates123111363paginates
pagoda10487873pagoda_
pagodas11367553pagodas
pail66141833pa_i__l
pain65647243pa_in__
painch133511323pa_inch
pained95622853pa_ined
painful1246403pa_inful
pains75138283pa_in_s
paint75443693pa_in_t
paints85921833pa_ints
painty114714753pa_inty
paisa76021073pa_isa_
paisan84417073pa_isan
paisas84317493pa_isas
palatal9310153palatal
paleal84716673pa_leal
palikar1335453palikar
paling93530133palin_g
palings103915823palings
pallial92911253pallial
palpal104112053pa_lpal
paludal1035683paludal
panel76023623pa__nel
panging113319113pangin_g
panini8314273panin_i
panino8315683panin_o
papal95820673pa__pal
papilla11127913papilla
papyral1445773papyral
parental10310943parental
parging113318603pargin_g
pargings123410163pargings
pariah114320583pari_ah
parian83223963pari_an
parians93519733parians
parietal1048773parietal
paring94236493parin_g
parings104219213parings
parral85517533pa_rral
partial92616263partial
pascal10812373pa_scal
paschal14157243paschal
passional1146043passional
pastina93914593pastina_
pastinas103712153pastinas
patagial1157173patagi_al
paternal1038333paternal
patin76832853patin__
patinaed11407833patinaed
patinate103016313patinate
patine85328123patin_e
patined105114783patined
patines95225763patines
patins87528783patin_s
patronal1048653patronal
pausal81511963pa_usal
pavin105623203pavin__
paving124519743pavin_g
pavings134011633pavings
pavins114919663pavin_s
pawing124519553pawin_g
paying123722163payin_g
pelagial1146543pelagi_al
penal75228373p__enal
penial84120893peni_al
perineal1049193perineal
phial10313203p_hi_al
phonal11310383p_honal
pial65636703p__i_al
pibal95217323p__ibal
pical95524373p__ical
pina65842633p__ina_
pinas75434453p__inas
pineal84817683p__ineal
pinnal84814273p_innal
pipal95118353p__ipal
piscinal1285843piscinal
plagal948573plag__al
platina94413643platina_
platinas103610313platinas
pleonal937243pleonal
plical10411683p_lical
preanal9310713preanal
primal104014623p_rimal
pygidial1543303pygidial
racial83419243raci_al
radial74020393radi_al
radical103312793radical
raging85126433ragin_g
ragingly1337863ragingly
rational8412543rational
regina75317143regina_
reginae84713453reginae
reginas85614063reginas
regional9438783regional
regnal74812933reg_nal
retinal75318353retinal
rhinal9510193_rhinal
ruminal9289993ruminal
sagittal943283sagittal
sahiwal1344443sahiwal
salina64221123salina_
salinas73116093salinas
seminal91213413seminal
signal73711483sig_nal
spacial1138763spaci_al
spatial9310323spati_al
spinal84915313_spinal
staminal1046983staminal
tarnal63716503ta_rnal
tegminal1144453tegminal
tragical1148213tragical
trinal6516963_trinal
uncinal959963uncinal
urinal6614123_urinal
vaccinal1544903vaccinal
vagal94613633vag__al
vaginally1645233vaginally
vaginate123911083vaginate
vatical1239983vatical
veinal93812963_veinal
vicinal12268543vicinal
viminal12288823viminal
vinal85725813__vinal
virginal1244573virginal
waging114318383wagin_g

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.406440125.6
2DLD Change Limit1340272406.23621492.5
3Display Results2402400.0763157.9
 (SQL Overall)1786912406.71826598.8
 
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.