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

118 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
pavin10562320(None) 
mavin105722951mavin
pain65647241pa_in
patin76832851patin
pavan106518471pavan
pavid115717001pavid
paving124519741paving
pavins114919661pavins
pavis106422731pavis
ravin85624651ravin
savin84625081savin
spavin114210651spavin
agin56132712_agin
ain37579092_a_in
akin86328032_akin
amin66042252_amin
avian84616052_avian
avid88325962_avid
avion84218342_avion
ayin76331742_ayin
basin75026922basin
cabin94820942cabin
cain65643912ca_in
cavie104621592cavie
cavil103816492cavil
caving124822612caving
covin105621122covin
daven94916472daven
davit93424592davit
fagin9216572fagin
fain75840562fa_in
flavin1239302flavin
gain56042162ga_in
gamin84423002gamin
haven114718532haven
having134220372having
kain85334292ka_in
lain46146282la_in
lapin75222922lapin
laving104623572laving
layin84720332layin
levin84816412levin
main65345522ma_in
matin75132852matin
maven104816892maven
mavie104722562mavie
mavins115119182mavins
mavis105622722mavis
mayvin1436522mayvin
pacing114522752pacing
padi76331782padi_
padis86227142padis
paean77222722paean
paeon74819492paeon
pagan86121162pagan
paging104020402paging
paid75737482pa_id
paik105726802pa_ik
pail66141832pa_il
pains75138282pa_ins
paint75443692pa_int
pair66031512pa_ir
paling93530132paling
pan58466452pa__n
panic93923902panic
panini8314272panini
panino8315682panino
papain10313792papain
parian83223962parian
paring94236492paring
paris75145942paris
parvis116114802parvis
paten74827342paten
patina86022192patina
patine85328122patine
patins87528782patins
patio74426352patio
paulin8312982paulin
pavane114113442pavane
pavans115715592pavans
pave96133892pav_e
paved115525262paved
paver104225832paver
paves104833922paves
pavings134011632pavings
pavior1138532pavior
pavise114714802pavise
pawing124519552pawing
pawn94625302pa_wn
paying123722162paying
pein65834942p_ein
pekin111514422pekin
pin57066722p__in
plain74823302plain
purin75527592purin
pyin96823232p_yin
rain46251732ra_in
raven84723442raven
ravine95522222ravine
raving105128852raving
ravins94622562ravins
rawin85521472rawin
sabin74924952sabin
sain45551292sa_in
sarin55239252sarin
sasin54626572sasin
satin55935222satin
savine94220282savine
saving104724512saving
savins93923132savins
spavie113611382spavie
spavins12419322spavins
tain45548072ta_in
takin94921302takin
vain75233002va_in
wain75840202wa_in
waving134018202waving
zayin174512042zayin

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.313570897.8
2DLD Change Limit538001181.53035163.4
3Display Results1181180.0333575.8
 (SQL Overall)1786911181.87695251.1
 
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.