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

288 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
pavisers1338744(None) 
paviser12489091paviser_
pavises125315491pavise_s
advisers12135002advisers
cavilers1348112cavilers
devisers12339862devisers
kaisers11369272ka_isers
lavishers1564642lavishers
mavises122812992mavise_s
paniers94717332pani_ers
parises94827182parise_s
parsers94118152pa_rsers
parvises133911912parvise_s
passers94717752pa_ssers
pausers94113222pa_users
pavers115021822pav__ers
paviors1237602pavi_ors
paviours1343612paviours
pavise114714802pavise__
pavisses13397102pavisses
poisers94214432p_oisers
praisers103410832praisers
raisers73617392ra_isers
ravishers1564782ravishers
revisers113511932revisers
abasers95311973_abasers
abiders104011083_abiders
abusers94710553_abusers
advisees12154133advisees
adviser11135783adviser_
advises11138973advise_s
advisors12143903advisors
aiders74524633_a_iders
aimers84621913_a_imers
airers64922313_a_irers
aivers94822323_a_ivers
aliners74717723_aliners
amusers94610193_amusers
anises64826693_anise_s
apposers1236283apposers
apprisers1345053apprisers
arises65233803_arise_s
avers85127313_av__ers
avisos95410483_avis_os
avoiders1254793_avoiders
avosets1036663_avosets
avowers1336333_avowers
axises134413993_axise_s
bailers94221353ba_ilers
baiters94619303ba_iters
banishers14258053banishers
banisters11189473banisters
bruisers10307953bruisers
cahiers123510673cahi_ers
calibers1238523calibers
calipers1249443calipers
camises114218463camise_s
canisters112310193canisters
canvasers14265353canvasers
causers94014793ca_users
cavers115026843cav__ers
caviares1337993caviares
caviars1238623cavi_ars
cavies114525003cavi_e_s
caviler1249063caviler_
cavillers1435613cavillers
claviers1367103clavi_ers
cruisers10438273cruisers
daikers124010313da_ikers
daises74318983da_ise_s
davies105020513davi_e_s
devisees12358283devisees
deviser114212393deviser_
devises114116763devise_s
devisors12347253devisors
dividers13257213dividers
diviners12308353diviners
divisors12255693divisors
enviers1036993envi_ers
favisms1535443favis_ms
favorers1465493favorers
favuses1336183favuse_s
gainers84214593ga_iners
gaiters83516543ga_iters
ganisters10248313ganisters
gassers84714633ga_ssers
hailers104017263ha_ilers
havers124721483hav__ers
haviors1347383havi_ors
haviours1443843haviours
hawsers13409483ha_wsers
inviters11359643inviters
jailers144114043ja_ilers
kaiser103610373ka_iser_
lamisters1157123lamisters
lapises93513463lapise_s
lapsers93911053la_psers
lasers64925703la__sers
laveers10329363lav_eers
lavers94526363lav__ers
lavisher1445083lavisher_
lavishes1457403lavishes
leviers103510343levi_ers
liviers104211073livi_ers
magisters1235803magisters
mailers94420333ma_ilers
maimers113813043ma_imers
mariners103113863mariners
masers84623453ma__sers
mavies114923193mavi_e_s
misers85025703__misers
nailers73215893na_ilers
navicert1344883navicert
navicerts1441643navicerts
navies95218623navi_e_s
pacers105124543pa__cers
pacier105018683paci_er_
pacifiers1645463pacifiers
packers153818893pa_ckers
padders113312873pa_dders
paddlers12329153paddlers
pagers94423253pa__gers
painters103013023painters
pairs75325833pa_i__rs
paisans93614753pa_isans
paisas84317493pa_is_as
paise75028333pa_ise__
paisleys1333343pa_isleys
palavers1337993palavers
palier85023563pali_er_
palikars1445083palikars
palmers113513623pa_lmers
palmisters1444673palmisters
palsies94420273palsie_s
palters94021683pa_lters
pampers133615933pa_mpers
panders103423733pa_nders
panier84425503pani_er_
panners93621273pa_nners
panniers10488853panniers
pansies94521983pansie_s
panthers13510783panthers
panzers184012013pa_nzers
paperers122410453paperers
papers105125323pa__pers
papisms13238543papis_ms
papistry1543723papistry
papists112110453papis_ts
paraders113113113paraders
pardners11269193pardners
parers85530743pa__rers
pareses94718883parese_s
paries84742513pari_e_s
parishes13314753parishes
parkers133816873pa_rkers
parriers103612903parriers
parsecs11429923pa_rsecs
parser84822373pa_rser_
parses85534703pa_rse_s
partiers103514243partiers
partners102711133partners
partyers13277763partyers
parvise124211693parvise__
paseos88015813pa__seos
pases75346503pa__se_s
passels93913023pa_ssels
passer84721033pa_sser_
passes86030473pa_sse_s
pasters94531733pa_sters
pastises103616053pastise_s
patchers153413303patchers
paters84935833pa__ters
patines95225763patine_s
patissiers1242123patissiers
patsies93919483patsie_s
patters94825193pa_tters
patzers184210573pa_tzers
paupers114311073pa_upers
pauser84415963pa_user_
pauses84621473pa_use_s
pavanes123612653pavane_s
paver104225833pav__er_
paves104833923pav__e_s
pavings134011633pavi_ngs
pavins114919663pavi__ns
pavior1138533pavi_or_
paviour1244623paviour_
pavis106422733pavi___s
pavisse12546813pavis_se
pawers114818783pa__wers
pawners124311073pa_wners
payers114621823pa__yers
peavies122213403peavi_e_s
peises84125043p_eise_s
pelvises1337273pelvise_s
penises9318193penise_s
perusers10328803perusers
pharisees1444633pharisees
piers75926333p__i_ers
pikers124717393p__ikers
pipers104318663p__ipers
pishers123815753p__ishers
pissers95014753p_issers
pitiers93812653piti_ers
plaisters1137813plaisters
plaiters103512633plaiters
planishers1584773planishers
pleasers104010293pleasers
pliers84715153p_li_ers
poetisers1145303poetisers
poiser84217243p_oiser_
poises84226543p_oise_s
policers12259993policers
polishers1477603polishers
posers84223973p__osers
praiser93413943praiser_
praises94121103praise_s
praxises1739063praxise_s
pressers103215023pressers
previses133814283previse_s
previsors14126483previsors
pricers113915063p_ricers
priers84521193p_ri_ers
primers114215673p_rimers
prisere9310943p_risere
priseres10310823p_riseres
prises84133173p_rise_s
prizers183911843p_rizers
promisers13268203promisers
prosers94219643p_rosers
providers1535593providers
pulsers94213153p_ulsers
pumicers1434353pumicers
punishers1434973punishers
pursers93916093p_ursers
raiders84615143ra_iders
railers74420663ra_ilers
raiser66620103ra_iser_
raises64826543ra_ise_s
rapiers95012873rapi_ers
rasers64526783ra__sers
ravagers1235573ravagers
ravelers113310863ravelers
raveners11309123raveners
ravers94628183rav__ers
ravines104220233ravine_s
ravisher1465463ravisher_
ravishes1478043ravishes
realisers9248323realisers
revilers114011693revilers
reviser104114663reviser_
revises104220533revise_s
revisors11379063revisors
revivers14389633revivers
risers64624783__risers
sailers73822323sa_ilers
samisens1035483samisens
savers93825923sav__ers
savines104417633savine_s
saviors1058993savi_ors
saviours1154273saviours
savorers1157223savorers
seisers73816393_seisers
spavies123012943spavi_e_s
tailers73720183ta_ilers
tamises92715973tamise_s
tapises92914013tapise_s
tarsiers8298533tarsiers
upraisers11174423upraisers
uprisers10206773uprisers
valises103516263valise_s
vanishers15186613vanishers
variers103712663vari_ers
vavasors14153653vavasors
viers85621953__vi_ers
vipers114914533__vipers
vises84427773__vise_s
visors92912223__visors
vivers124717363__vivers
wailers103916803wa_ilers
waisters113811523wa_isters
waiters104218623wa_iters
waivers133410053wa_ivers
waverers14318613waverers
wavers125022473wav__ers
wavier124613083wavi_er_
wavies125019843wavi_e_s
waviness1437723waviness

Search took 9 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.1701051123.5
2DLD Change Limit1461622888.62616944.4
3Display Results2882880.1062717.0
 (SQL Overall)1786912888.90220073.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.