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

420 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
paviser1248909(None) 
pavise114714801pavise_
pavisers13387441pavisers
pavises125315491pavises
adviser11135782adviser
caviler1249062caviler
deviser114212392deviser
kaiser103610372ka_iser
lavisher1445082lavisher
mavises122812992mavises
pacier105018682paci_er
paise75028332pa_ise_
palier85023562pali_er
panier84425502pani_er
parises94827182parises
parser84822372pa_rser
parvise124211692parvise_
parvises133911912parvises
passer84721032pa_sser
pauser84415962pa_user
paver104225832pav__er
pavior1138532pavi_or
paviour1244622paviour
pavis106422732pavis__
pavisse12546812pavisse
pavisses13397102pavisses
poiser84217242p_oiser
praiser93413942praiser
raiser66620102ra_iser
ravisher1465462ravisher
reviser104114662reviser
wavier124613082wavi_er
abaser86414343_abaser
abider95314463_abider
abuser85413683_abuser
advise10139223advise_
advised12136043advised
advisee11147153advisee
advisers12135003advisers
advises11138973advises
advisor11134163advisor
aider65431133_a_ider
aimer75926823_a_imer
airer54927893_a_irer
aiver85725163_a_iver
aliner65621983_aliner
amuser84712623_amuser
anise55129703_anise_
anises64826693_anises
apposer1147483apposer
appriser1246783appriser
arider74717743_arider
arise56436433_arise_
arisen65316793_arisen
arises65233803_arises
aver75931883_av__er
aviso85713963_avis_o
avisos95410483_avisos
avoider1155813_avoider
avoset9315673_avoset
avower1236823_avower
axised14438963_axised
axises134413993_axises
babier103515573babi_er
bailer85425253ba_iler
baiter84422553ba_iter
banisher13169183banisher
banister10199973banister
baser74828923ba__ser
bruiser9349573bruiser
cagier93715933cagi_er
cahier113615773cahi_er
cakier123115243caki_er
caliber1139733caliber
caliper11410963caliper
camise103319633camise_
camises114218463camises
canister101710853canister
canvaser13276553canvaser
causer84117783ca_user
caver105629063cav__er
caviar11310163cavi_ar
caviare1238373caviare
cavie104621593cavi_e_
cavies114525003cavi_es
caviled1348723caviled
cavilers1348113cavilers
caviller1337063caviller
clavier1239173clavi_er
cruiser93410433cruiser
daiker115113033da_iker
daises74318983da_ises
davies105020513davi_es
devise104215753devise_
devised123712563devised
devisee113812713devisee
devisers12339863devisers
devises114116763devises
devisor11357043devisor
divider12278953divider
diviner11369883diviner
divisor11345573divisor
easier64218463easi_er
envier939673envi_er
eviler94811893_eviler
fainer94717243fa_iner
fairer95212063fa_irer
falser93912413fa_lser
favism1437913favis_m
favisms1535443favisms
favorer1355883favorer
favuses1336183favuses
gainer74117493ga_iner
gaiter73819503ga_iter
gamier93617933gami_er
ganister9178993ganister
gasser75017773ga_sser
gassier83812573gassier
hailer94720343ha_iler
haver115124463hav__er
havior1248203havi_or
haviour1354823haviour
hawser125910843ha_wser
hazier184712403hazi_er
heavier13429423heavi_er
inviter104112313inviter
jailer134316683ja_iler
jivier16438613jivi_er
kaisers11369273ka_isers
lacier84020093laci_er
lakier104716273laki_er
lamister1037653lamister
lapises93513463lapises
lapser84113143la_pser
laser54633323la__ser
laveer94110423lav_eer
laver85031793lav__er
lavish124112983lavis_h
lavished1555133lavished
lavishers1564643lavishers
lavishes1457403lavishes
lazier154214613lazi_er
leavier10319993leavi_er
levier94013873levi_er
livier97514593livi_er
magister1136283magister
mailer84724183ma_iler
maimer104514593ma_imer
mariner93315993mariner
maser75029973ma__ser
massier93615223massier
matier84321523mati_er
mavie104722563mavi_e_
mavies114923193mavi_es
mavis105622723mavis__
mazier175013063mazi_er
miser75430403__miser
nailer64119363na_iler
naiver94311353na_iver
navicert1344883navicert
navies95218623navi_es
oakier104011393oaki_er
pacer96131613pa__cer
paciest112917803paciest
pacifier1557503pacifier
packer144223403pa_cker
padder103415493pa_dder
paddler113711553paddler
padis86227143padis__
pager84728203pa__ger
paiked135113433pa_iked
pained95622853pa_ined
painter93814563painter
pair66031513pa_i__r
paired95017523pa_ired
paisa76021073pa_is_a
paisan84417073pa_isan
paisas84317493pa_isas
paisley1235553pa_isley
palaver1238753palaver
paler75436933pa__ler
paliest93021603paliest
palikar1335453palikar
palish114718273palis_h
pallier94417163pallier
palmer105816543pa_lmer
palmier113312173palmier
palmister1345053palmister
palsied102911303palsied
palsies94420273palsies
palter84423263pa_lter
pamper124316663pa_mper
pander93725523pa_nder
paniers94717333pani_ers
panner84224763pa_nner
pannier93613353pannier
pansies94521983pansies
panther12611443panther
panzer174213233pa_nzer
paper95128663pa__per
paperer113111903paperer
papism122211513papis_m
papisms13238543papisms
papist102618743papis_t
papistry1543723papistry
papists112110453papists
pappier103511593pappier
parader103914863parader
pardner10239473pardner
parer75839903pa__rer
pareses94718883pareses
paries84742513pari_es
paris75145943paris__
parish115022353paris_h
parishes13314753parishes
parker124121373pa_rker
parrier93717653parrier
parse75236993pa_rse_
parsec105914483pa_rsec
parsed96323893pa_rsed
parsers94118153pa_rsers
parses85534703pa_rses
partier93520713partier
partner92811393partner
partyer12337873partyer
parvis116114803parvis__
pase65346863pa__se_
paseo77022513pa__seo
pases75346503pa__ses
passe75525693pa_sse_
passed94320943pa_ssed
passee84522023pa_ssee
passel85117003pa_ssel
passers94717753pa_ssers
passes86030473pa_sses
paster85734373pa_ster
pastier94320383pastier
pastises103616053pastises
patcher143515143patcher
pater74740723pa__ter
patine85328123patine_
patined105114783patined
patines95225763patines
patissier1143183patissier
patsies93919483patsies
patter84628263pa_tter
patzer173111643pa_tzer
pauper103511943pa_uper
pause75021833pa_use_
paused95114963pa_used
pausers94113223pa_users
pauses84621473pa_uses
pavane114113443pavane_
pavanes123612653pavanes
pave96133893pav__e_
paved115525263pav__ed
paveed12438893pav_eed
pavers115021823pav__ers
paves104833923pav__es
pavid115717003pavi__d
pavin105623203pavi__n
paving124519743pavi_ng
pavings134011633pavings
pavins114919663pavi_ns
paviors1237603paviors
paviours1343613paviours
pawer104422973pa__wer
pawkier16236613pawkier
pawner114212923pa_wner
payer105125723pa__yer
peakier134411443peaki_er
peatier94017233peati_er
peavies122213403peavi_es
peise75825773p_eise_
peised94817683p_eised
peises84125043p_eises
pelvises1337273pelvises
penises9318193penises
peruser93511373peruser
pharisee1347603pharisee
pier66035293p__i_er
piker115622843p__iker
pinier84024693pini_er
piper96523193p__iper
pipier104913983pipi_er
pisher114317753p__isher
pisser84416383p_isser
pitier84019823piti_er
plainer93811983plainer
plaister1068013plaister
plaiter93615393plaiter
planisher1495853planisher
platier93716293plati_er
pleaser93912343pleaser
plier75221283p_li_er
poetiser1037313poetiser
poise75127893p_oise_
poised94918473p_oised
poisers94214433p_oisers
poises84226543p_oises
pokier124914633poki_er
policer113112683policer
polisher1388073polisher
politer92417073politer
poser75128773p__oser
poxier153812113poxi_er
praise84419413praise_
praised104214813praised
praisers103410833praisers
praises94121103praises
praxises1739063praxises
preciser123411663preciser
presser93717623presser
previse123713793previse_
prevised143611073prevised
previses133814283previses
previsor13116303previsor
pricer103918293p_ricer
prier75027763p_ri_er
primer105118683p_rimer
prise74632613p_rise_
prised94322203p_rised
prisere9310943p_risere
prises84133173p_rises
privier122910453privier
prizer174714883p_rizer
promiser122510673promiser
proser84223463p_roser
prosier93817483prosier
provider1436703provider
pulser84215193p_ulser
pumicer1335063pumicer
punier84519223puni_er
punisher1335773punisher
purser85020473p_urser
pursier94012753pursier
pussier93711993pussier
racier85120973raci_er
raider74318743ra_ider
railer64524933ra_iler
raise54828053ra_ise_
raised76120333ra_ised
raisers73617393ra_isers
raises64826543ra_ises
rapider1067903rapider
rapier84019993rapi_er
raser55633413ra__ser
ravager1136553ravager
raveler104212463raveler
ravener104110733ravener
raver85631493rav__er
ravine95522223ravine_
ravined115411823ravined
ravines104220233ravines
ravish123414033ravis_h
ravished1555713ravished
ravishers1564783ravishers
ravishes1478043ravishes
realiser82512563realiser
reviler104314973reviler
revise94019743revise_
revised113815483revised
revisers113511933revisers
revises104220533revises
revisor10388733revisor
reviver134411373reviver
riser55431053__riser
sagier73717163sagi_er
sailer63526103sa_iler
samisen937673samisen
sassier73413233sassier
savager1137133savager
saver84831253sav__er
savine94220283savine_
savines104417633savines
savior9710173savi_or
saviour1035213saviour
savorer1057883savorer
savvier1335483savvier
seiser65318343_seiser
spacier114011633spaci_er
sparser94311483spa_rser
spavie113611383spavi_e_
spavies123012943spavi_es
spaviet123011923spavi_et
spavined1434333spavined
tailer63823733ta_iler
tamises92715973tamises
tapises92914013tapises
tarsier74119253tarsier
unwiser1037123unwiser
upraiser10175843upraiser
upriser9218763upriser
vainer93714573va_iner
valise92917643valise_
valises103516263valises
vanisher14167453vanisher
varier94619353vari_er
vavasor13143603vavasor
vier75428153__vi_er
viler86324163__viler
viper105017303__viper
vise75632673__vise_
vised95518763__vised
vises84427773__vises
visor82512833__visor
vivider14265623vivider
wailer93720323wa_iler
waister103812383wa_ister
waiter94321253wa_iter
waiver124212713wa_iver
wanier93920683wani_er
warier93722893wari_er
waver115025703wav__er
waverer13319523waverer
wavies125019843wavi_es
waviest134513073waviest
waxier16439903waxi_er
wiser85522803__wiser
zanier154314713zani_er

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.393454684.5
2DLD Change Limit1340274205.82623005.0
3Display Results4204200.1562692.3
 (SQL Overall)1786914206.37528030.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.