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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

89 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
pavid11571700(None) 
avid88325971_avid
paid75737491pa_id
paved115525261paved
pavin105623201pavin
pavis106422731pavis
acid77533402_acid
aid49269092_a_id
amid77036362_amid
aphid115515392aphid
arid57642722_arid
avoid95516682_avoid
bovid111011622bovid
caid77837542ca_id
canid85526342canid
caved116227562caved
cavie104621592cavie
cavil103816492cavil
davit93424592davit
eaved95924502eaved
gadid85517382gadid
gravid113710982gravid
halid94424982halid
impavid1544552impavid
laid56439152la_id
laved95028592laved
livid96714422livid
maid75537672ma_id
mavie104722562mavie
mavin105722952mavin
mavis105622722mavis
navaid1037652navaid
paced106931682paced
pad68057332pa__d
padi76331792padi_
padis86227142padis
paged95926782paged
pagod95013682pagod
paik105726802pa_ik
pail66141832pa_il
pain65647242pa_in
pair66031512pa_ir
paled85538722paled
pallid93915292pallid
paned85437182paned
panic93923902panic
pard76441322pa_rd
pardi85723952pardi
pared86946762pared
paris75145942paris
parvis116114802parvis
pated85237842pated
patin76832852patin
patio74426362patio
pavan106518472pavan
pave96133892pav_e
paveed12438892paveed
paver104225832paver
paves104833922paves
paving124519742paving
pavins114919662pavins
pavior1138542pavior
pavise114714802pavise
pawed115725612pawed
payed115925932payed
placid114012542placid
plaid85118302plaid
pyoid11513762pyoid
qaid146023852qa_id
rabid84520782rabid
raid55243082ra_id
ranid66429332ranid
rapid86422032rapid
raved94931432raved
ravin85624652ravin
said55742122sa_id
sapid84720932sapid
saved95127112saved
savin84625082savin
sayid95516722sayid
sparid94016932sparid
spavie113611382spavie
spavin114210652spavin
tabid84418262tabid
valid94618392valid
vapid115614282vapid
vid77241822__vid
vivid125112312vivid
waved125223582waved

Search took 4 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.330541487.9
2DLD Change Limit53800893.35616031.0
3Display Results89890.0165562.5
 (SQL Overall)178691893.70248268.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.