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

191 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
pavisses1339710(None) 
pavises125315491pavi_ses
pavisse12546811pavisse_
kavasses1544302kavasses
lavishes1457402lavishes
mavises122812992mavi_ses
parises94827182pari_ses
parishes13314752parishes
parvises133911912parvi_ses
passes86030472pa__sses
pavise114714802pavi_se_
paviser12489092pavi_ser
pavisers13387442pavisers
pelisses1048482pelisses
pisses84525082p__isses
plisses94411772p_lisses
prisses94816712p_risses
ravishes1478042ravishes
abioses9311493_abioses
abysses1234863_abysses
advisees12154133advisees
advises11138973advi_ses
aisles64721143_a_isles
aliases7914493_aliases
amasses93912853_amasses
anises64826693_ani_ses
arises65233803_ari_ses
asses55629283_a__sses
avenses1049643_avenses
avgases11106313_avgases
avgasses1284193_avgasses
aviates10313063_aviates
avisos95410483_avi_sos
avulses1035433_avulses
axises134413993_axi_ses
badasses1136173badasses
bagasses1136313bagasses
banishes131812463banishes
basses85428303ba__sses
batistes1039713batistes
bekisses1434243bekisses
blisses94911513_blisses
brisses94314313_brisses
camasses12388973camasses
camises114218463cami_ses
canvasses14286043canvasses
capiases1239253capiases
caresses10314063caresses
cassises103811743cassises
caviares1337993caviares
cavies114525003cavi__es
cavities131412613cavities
cuisses9319883_cuisses
daises74318983da_i_ses
daisies84217093da_isies
danishes121710493danishes
davies105020513davi__es
devisees12358283devisees
devises114116763devi_ses
disses75225963__disses
famishes1658283famishes
favisms1535443favi_sms
favuses1336183fav_uses
gasses75724783ga__sses
gausses8308693ga_usses
gneisses933673gneisses
harasses11311033harasses
harissas1145983harissas
hisses94719353__hisses
karosses1236493karosses
kisses104217333__kisses
kumisses1443583kumisses
kvasses14365503_kvasses
lapises93513463lapi_ses
lasses64827593la__sses
lavashes1445573lavashes
lavished1555133lavished
lavisher1445083lavisher
lavishers1564643lavishers
lavishest1554883lavishest
marishes13512553marishes
masses85028713ma__sses
mavies114923193mavi__es
metisses1036833metisses
misses85130873__misses
navies95218623navi__es
pacifies15311223pacifies
paisans93614753pa_isans
paisas84317493pa_i_sas
paise75028333pa_i_se_
paisley1235553pa_isley
paisleys1333343pa_isleys
palisades1245613palisades
palliasses1283583palliasses
palsies94420273pa_lsies
panfishes1737593panfishes
panicles121010113panicles
pansies94521983pa_nsies
papisms13238543papi_sms
papists112110453papi_sts
papooses1248053papooses
pareses94718883pa_reses
paries84742513pari__es
parietes10714543parietes
parities10522973parities
parses85534703pa__rses
parvise124211693parvi_se_
pases75346503pa___ses
pashes115828393pa__shes
passe75525693pa__sse_
passed94320943pa__ssed
passee84522023pa__ssee
passel85117003pa__ssel
passels93913023pa__ssels
passer84721033pa__sser
passers94717753pa__ssers
passives13228823passives
passus83610293pa__ssus
passuses1036773passuses
pastes85233913pa__stes
pastises103616053pastises
pathoses13412773pathoses
patines95225763pati_nes
patissier1143183patissier
patissiers1242123patissiers
patnesses111611793patnesses
patsies93919483pa_tsies
pauses84621473pa__uses
pavanes123612653pav_anes
paves104833923pav___es
pavings134011633pavi_ngs
pavins114919663pavi__ns
paviors1237603pavi_ors
paviours1343613paviours
pavis106422733pavi___s
peavies122213403peavi__es
peises84125043p_ei_ses
pelisse967063pelisse_
pelvises1337273pelvi_ses
penises9318193peni_ses
perishes13313753perishes
pharisees1444633pharisees
pishes114722103p__ishes
pissed94816933p__issed
pisser84416383p__isser
pissers95014753p__issers
pistes85325633p__istes
planishes14138523planishes
plisse8368403p_lisse_
plusses93510693p_lusses
poises84226543p_oi_ses
polishes13711783polishes
posses85128803p__osses
praises94121103prai_ses
praxises1739063praxi_ses
premisses13288763premisses
presses93523153p_resses
previses133814283previ_ses
prises84133173p_ri_ses
prissed103311263p_rissed
prissies101712003p_rissies
prosses94019513p_rosses
provisoes1446653provisoes
puisnes937423p_uisnes
punishes1338113punishes
pusses84322843p__usses
radishes1269463radishes
radiuses937043radiuses
raises64826543ra_i_ses
ravines104220233ravi_nes
ravished1555713ravished
ravisher1465463ravisher
ravishers1564783ravishers
revises104220533revi_ses
sasses64124393sa__sses
savines104417633savi_nes
sisses64520603__sisses
spavies123012953spavi__es
speisses10245693speisses
swisses10417143_swisses
tamises92715973tami_ses
tapises92914013tapi_ses
tasses64826763ta__sses
valises103516263vali_ses
vanishes141610753vanishes
vises84427773__vi_ses
wavicles1633783wavicles
wavies125019843wavi__es
waviness1437723waviness
wavinesses16199283wavinesses
wisses94619603__wisses

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621916.79621507.1
3Display Results1911910.0762513.2
 (SQL Overall)1786911917.29524495.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.