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 “pavis” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

190 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
pavis10642273(None) 
mavis105622721mavis
padis86227141padis
paris75145941paris
parvis116114801parvis
paves104833921paves
pavid115717001pavid
pavin105623201pavin
pavins114919661pavins
pavise114714801pavise
ahis76135382_ahis
ais39083572_a_is
amis66445322_amis
anis45746462_anis
aphis105917132aphis
apsis75718292apsis
aves76142602_aves
avid88325962_avid
aviso85713962_aviso
avos77227012_avos
axis116127912_axis
basis75429862basis
cadis84428502cadis
caves105639702caves
cavie104621592cavie
cavies114525002cavies
cavil103816492cavil
cavils114014392cavils
dais57040702da_is
davies105020512davies
davit93424592davit
davits104012362davits
eaves85231992eaves
favas115618592favas
faves115331422faves
favism1437912favism
favus114311732favus
gadis74825292gadis
hajis156716282hajis
haves116034872haves
javas155915422javas
kadis105921062kadis
kakis86116842kakis
kavas125919952kavas
lapis76223152lapis
laris54737462laris
lavas85422222lavas
laves86039152laves
lavish124112982lavish
lavs76734152lav_s
levis85818552levis
mavie104722562mavie
mavies114923192mavies
mavin105722952mavin
mavins115119182mavins
maxis145721562maxis
nabis76020582nabis
naris55735292naris
naves87030382naves
navies95218622navies
nazis145216082nazis
oasis56422552oasis
oaves84925612oaves
pacas96029402pacas
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padi76331782padi_
pads76742952pa_ds
pages85235072pages
paid75737482pa_id
paik105726802pa_ik
paiks114719852paiks
pail66141832pa_il
pails75833062pails
pain65647242pa_in
pains75138282pains
pair66031512pa_ir
pairs75325832pairs
paisa76021072pa_isa
paise75028332pa_ise
palais8420422palais
pales75753802pales
palish114718272palish
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
panes76148692panes
pangs84628662pangs
panic93923902panic
panics103815362panics
pans65855732pa_ns
pants76536922pants
papas94927492papas
papism122211512papism
papist102618742papist
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paries84742512paries
parish115022352parish
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
parvise124211692parvise
parvos116614752parvos
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pastis84924322pastis
pasts75936502pasts
pates76047892pates
paths105521382paths
patin76832852patin
patins87528782patins
patio74426352patio
patios85221782patios
patois84319362patois
pats66460852pa_ts
pavan106518472pavan
pavans115715592pavans
pave96133892pav_e
paved115525262paved
paver104225832paver
pavers115021822pavers
paving124519742paving
pavings134011632pavings
pavior1138532pavior
paviors1237602paviors
paviser12489092paviser
pavises125315492pavises
pavisse12546812pavisse
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
peavies122213402peavies
pelvis113610322pelvis
penis75129322penis
peris75537072peris
phasis114614922phasis
phis95724902p_his
pikis115116392pikis
pilis75825202pilis
pis56362032p__is
pois66539042p_ois
polis74731162polis
praxis154012252praxis
psis68120342p_sis
pubis94616472pubis
pulis74225602pulis
puris75332022puris
pyxis17458632pyxis
qadis155917852qadis
ragis66325602ragis
rais45252622ra_is
rakis95323442rakis
ranis55235832ranis
raves85441972raves
ravin85624652ravin
ravins94622562ravins
ravish123414032ravish
sadis64930852sadis
sakis95323672sakis
saris54544952saris
satis55633682satis
saves85838632saves
savin84625082savin
savins93923132savins
spahis11310382spahis
spavie113611382spavie
spavies123012942spavies
spavin114210652spavin
spavins12419322spavins
tamis76728732tamis
tapis75028862tapis
tavs75630972tav_s
taxis126821972taxis
vavs105720432vav_s
vis66747612__vis
wadis95223962wadis
waves115633922waves
wavies125019842wavies
yagis95416572yagis

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001901.40638264.6
3Display Results1901900.0464130.4
 (SQL Overall)1786911901.762101413.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.