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

186 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
pavisse1254681(None) 
pavise114714801pavi_se
pavises125315491pavises
pavisses13397101pavisses
mavises122812992mavises
paise75028332pa_i_se
parises94827182parises
parvise124211692parvi_se
parvises133911912parvises
passe75525692pa__sse
pavins114919662pavins_
pavis106422732pavi_s_
paviser12489092paviser
pelisse967062pelisse
plisse8368402p_lisse
advise10139223advi_se
advisee11147153advisee
advises11138973advises
aisle55223193_a_isle
amiss75823073_amiss_
anise55129703_ani_se
anises64826693_anises
ariose64818723_ariose
arise56436433_ari_se
arises65233803_arises
averse95811183_averse
aviate9315203_aviate
aviso85713963_avi_so
avisos95410483_avisos
avulse935843_avulse
axises134413993_axises
bagasse1035143bagasse
batiste939743batiste
camise103319633cami_se
camises114218463camises
caviare1238373caviare
cavie104621593cavi__e
cavies114525003cavies_
cavils114014393cavils_
cuisse8318333_cuisse
daises74318983da_ises
davies105020513davies_
davits104012363davits_
devise104215753devi_se
devisee113812713devisee
devises114116763devises
favism1437913favi_sm
favisms1535443favisms
favuses1336183favuses
harissa1035503harissa
kavass13517303kavass_
kavasses1544303kavasses
lapises93513463lapises
lavish124112983lavi_sh
lavished1555133lavished
lavisher1445083lavisher
lavishes1457403lavishes
masse75125293ma__sse
mavie104722563mavi__e
mavies114923193mavies_
mavins115119183mavins_
mavis105622723mavi_s_
metisse936503metisse
navies95218623navies_
paciest112917803paciest
padis86227143padi_s_
paiks114719853pa_iks_
pails75833063pa_ils_
pains75138283pa_ins_
pairs75325833pa_irs_
paisa76021073pa_i_sa
paisan84417073pa_isan
paisas84317493pa_isas
paisley1235553pa_isley
paliest93021603paliest
palisade1145833palisade
palish114718273pali_sh
palliasse1173023palliasse
palsies94420273palsies
panicle11129983panicle
panics103815363panics_
pansies94521983pansies
papism122211513papi_sm
papisms13238543papisms
papist102618743papi_st
papists112110453papists
papoose1147513papoose
pappose1047413pappose
pareses94718883pareses
paries84742513paries_
paris75145943pari_s_
parish115022353pari_sh
parishes13314753parishes
parse75236993pa__rse
parses85534703pa_rses
parvis116114803parvi_s_
pase65346863pa___se
pases75346503pa__ses
pass65239953pa__ss_
passed94320943pa__ssed
passee84522023pa_ssee
passel85117003pa__ssel
passer84721033pa__sser
passes86030473pa__sses
passive12239593passive
paste74932953pa__ste
pastises103616053pastises
patinae95414403patinae
patine85328123pati_ne
patines95225763patines
patins87528783patins_
patios85221783patios_
patissier1143183patissier
patsies93919483patsies
pause75021833pa__use
pauses84621473pa_uses
pavane114113443pav_ane
pavanes123612653pavanes
pavans115715593pavans_
pave96133893pav___e
pavers115021823pavers_
paves104833923pav_es_
pavid115717003pavi__d
pavin105623203pavi__n
paving124519743pavi_ng
pavings134011633pavings
pavior1138533pavi_or
paviors1237603paviors
paviour1244623paviour
pavisers13387443pavisers
peavies122213403peavies_
peise75825773p_ei_se
peises84125043p_eises
pelisses1048483pelisses
pelvises1337273pelvises
penises9318193penises
pharisee1347603pharisee
piss65033333p__iss_
pissed94816933p__issed
pisser84416383p__isser
pisses84525083p__isses
piste75824603p__iste
plisses94411773p_lisses
pluviose1342663pluviose
poise75127893p_oi_se
poises84226543p_oises
posse74722273p__osse
praise84419413prai_se
praises94121103praises
praxises1739063praxises
previse123713793previ_se
previses133814283previses
prise74632613p_ri_se
prises84133173p_rises
priss74623893p_riss_
prissed103311263p_rissed
prisses94816713p_risses
prissy11347853p_rissy
puisne856353p_uisne
raise54828053ra_i_se
raises64826543ra_ises
ravine95522223ravi_ne
ravines104220233ravines
ravins94622563ravins_
ravish123414033ravi_sh
ravished1555713ravished
ravisher1465463ravisher
ravishes1478043ravishes
revise94019743revi_se
revises104220533revises
savine94220283savi_ne
savines104417633savines
savins93923133savins_
spavie113611383spavi__e
spavies123012943spavies_
spavins12419323spavins_
tamises92715973tamises
tapises92914013tapises
tasse54821843ta__sse
valise92917643vali_se
valises103516263valises
vise75632673__vi_se
vises84427773__vises
wavicle1534063wavicle
wavies125019843wavies_
waviest134513073waviest

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.406440125.6
2DLD Change Limit1340271866.54620474.6
3Display Results1861860.0632952.4
 (SQL Overall)1786911867.01525472.7
 
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.