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

241 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
prepaved1617723(None) 
prepared132210871prepared
prepave14228871prepave_
prepaves15189191prepaves
repaved133311131_repaved
greaved12408912gre_aved
preaged11612332pre_aged
preaver121011612pre_aver
prebaked1737172prebaked
predated12513272predated
prefaced1638422prefaced
prefaded1537822prefaded
prepacked20155652prepacked
prepaid12310132prepa_id
prepare111913622prepare_
preparer12169642preparer
prepares122014162prepares
prepasted14137672prepasted
preplaced1676482preplaced
prepped11329902prep_ped
presaged1238802presaged
pretaped13339132pretaped
reaved104523922_re_aved
repave114813872_repave_
repaves123513652_repaves
behaved16176683_behaved
bereaved1446403bereaved
braved124817443br__aved
breaded115014063bre_aded
breamed124011593bre_amed
cleaved134010483cle_aved
craved125417773cr__aved
creaked143413233cre_aked
creamed123913713cre_amed
creased104315583cre_ased
created104323453cre_ated
cremated133412963cremated
crenated113013913crenated
creped114115703crep__ed
deaved114916553_de_aved
depraved1535543_depraved
dreaded103612023dre_aded
dreamed114310633dre_amed
eaved95924503__e_aved
freaked15399703fre_aked
graved114818813gr__aved
greased93812393gre_ased
greave104611493gre_ave_
greaves113311443gre_aves
heaved134717863_he_aved
leaved105719023_le_aved
palpated13249763palpated
paved115525263___paved
peaced115818913p_e_aced
peaked136117403p_e_aked
pealed95322813p_e_aled
peavey14398793p_e_avey
pedaled113711893p_edaled
peeped113915393peep__ed
peeved124112893p_e_eved
pepped103113403p_ep_ped
pervaded1535373pervaded
petaled103614153p_etaled
phreaked1834493phre_aked
pleaded113511263ple_aded
pleased103712073ple_ased
pleated103816633ple_ated
prated94924923pr__ated
prayed124815433pr__ayed
preached163412063preached
preacted132710943preacted
prearmed1397993prearmed
preavers13910263pre_avers
prebade12310283prebade_
prebake1539093prebake_
prebakes1639013prebakes
precava1445093precav_a
precavae1544813precavae
precaval1544723precaval
preceded1438293preceded
precised133213413precised
precited133013813precited
precoded1438863precoded
precured1339993precured
predate10616893predate_
predates11615813predates
predive13511083predive_
predried12309573predried
preed85128123pre___ed
preened103214993pre_ened
prefabbed1942323prefabbed
preface14510923preface_
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade_
prefades1439533prefades
prefiled143310573prefiled
prefired144310753prefired
prefixed21357703prefixed
pregame1239553pregame_
pregames1339003pregames
preheated1539813preheated
prelate9519693prelate_
prelates10418573prelates
prelives13310383prelives
preloaded1335923preloaded
preluded1236473preluded
premade12311443premade_
premed114617763pre__med
premised133013193premised
premixed20338013premixed
prename11412643prename_
prenames12311643prenames
preowned1435213preowned
prepack1757643prepa_ck
prepacks1836583prepacks
preparedly1842993preparedly
preparers13197673preparers
prepaste12139083prepaste
prepastes13128823prepastes
prepaving1787233prepaving
prepay13310313prepa__y
prepays1437483prepa_ys
preplace1488983preplace_
preplaces1578753preplaces
preplanned1543503preplanned
preppie1058093preppie_
preppier1156643preppier
preppies1149683preppies
prepreg12165963prep_reg
prepriced1676643prepriced
prepubes1436053prepubes
prepuce1337833prepuce_
prepuces1438583prepuces
prerace11414123prerace_
presage10312293presage_
presager1138443presager
presages11312203presages
presale9416353presale_
presales10315263presales
preserved15107563preserved
preshaped1745523preshaped
presided12410553presided
presoaked1635653presoaked
presolved1545273presolved
pressed103317313pre_ssed
presumed1337973presumed
pretape113511623pretape_
pretapes122811533pretapes
pretasted12147963pretasted
pretravel1444123pretravel
prettied1159253prettied
pretyped16306123pretyped
prevailed1536043prevailed
prevalued1544553prevalued
prevised143611073prevised
prevued1337143pre_vued
prewarmed17104563prewarmed
prewarned1594773prewarned
prewashed1843923prewashed
prewired14358473prewired
preyed125313203pre__yed
probated13410863probated
profaned14207973profaned
pronated11414053pronated
propane112716153propane_
propanes122415823propanes
propined133111503propined
proponed132412033proponed
proposed132011073proposed
propped113311953prop_ped
prorated11513713prorated
proved125016033pr__oved
pupated12319353p_upated
raved94931433_r__aved
reamed94326123_re_amed
reaped94122453_re_aped
reared75930013_re_ared
reave84528023_re_ave_
reaver94524733_re_aver
reaves94127573_re_aves
rebated103619703_rebated
recaned102817203_recaned
redated93120923_redated
reeved104118713_re_eved
refaced133713573_refaced
regaled93615963_regaled
regave104713383_regave_
reived104518133_re_ived
relaced103517213_relaced
related83327573_related
relaxed153312533_relaxed
relayed113212753_relayed
relived115114683_relived
remated103522473_remated
removed134611313_removed
renamed103114523_renamed
repacked17188743_repacked
repaid94716323_repa_id
repaired1148953_repaired
repand95316063_repa_nd
repanel939963_repanel
repaper11310023_repaper
reparked15208923_reparked
repassed11229273_repassed
repasted112611533_repasted
repealed113211873_repealed
repeated113117443_repeated
repined104918773_repined
replaced133211403_replaced
replated112817523_replated
replayed14248633_replayed
repled93319783_rep_led
replied103914453_replied
reposed103616273_reposed
repped114616723_rep_ped
reproved14199473_reproved
reputed104613483_reputed
resawed113111183_resawed
reshaved1536873_reshaved
respaced1338503_respaced
respaded1238133_respaded
retaped103814283_retaped
retaxed153512233_retaxed
revived144211653_revived
revved13469723_re_vved
rewaked153811903_rewaked
rewaxed18409343_rewaxed
reweaved1535953_reweaved
sepaled10510593_sepaled
sheaved143411633she_aved
sleaved113611133sle_aved
treaded95014283tre_aded
treated83618703tre_ated
trepanned1243913trepanned
unpaved133410053_unpaved
unprepared1543023unprepared
upheaved1733763uphe_aved
upreared1137073upre_ared
weaved133913483_we_aved
wreaked15369023wre_aked

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.406440125.6
2DLD Change Limit1461622416.84321359.3
3Display Results2412410.0962510.4
 (SQL Overall)1786912417.34524328.3
 
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.