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

170 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
prepack175764(None) 
prepacks1836581prepacks
repack142412161_repack
preach133613922pre_ach
preact103220392pre_act
preface14510922preface
prelacy1437582prelacy
prepacked20155652prepacked
prepaid12310132prepaid
prepare111913622prepare
prepave14228872prepave
prepay13310312prepa_y
prepays1437482prepays
preplace1488982preplace
prepuce1337832prepuce
prerace11414122prerace
prerock1536722prerock
repacks15269542_repacks
repark123511712_repark
rerack122513162_rerack
retack122612822_retack
tripack1565672tripack
arepa75615563arepa__
arepas85515703arepa_s
arrack121110253ar_rack
bareback1846093bareback
bipack1636523_bipack
breach134213723bre_ach
break115319403bre_a_k
calpack17338333calpack
crack134120533cr__ack
creak115418433cre_a_k
dieback1646913dieback
dreck124812803dre__ck
epact94921533__epact
fireback1946953fireback
freak125115243fre_a_k
gripsack1742583gripsack
hardpack2043923hardpack
kreplach1942613kreplach
manpack1746063manpack
mudpack1843593mudpack
overpack1966623overpack
pack125535443___pack
papacy1547493p_apacy
payback2056453payback
peace95026083p_e_ace
peach125422493p_e_ach
peak106535203p_e_a_k
peck125730683p_e__ck
peptalk1554823p_eptalk
phreak1536153phre_a_k
plack135017843p__lack
pleach134211243ple_ach
pollack1567333pollack
portapack1951813portapack
prank115019453pr__ank
preachy17307313pre_achy
preacts113211363pre_acts
preamp1238993pre_amp
prearm104512353pre_arm
prebade12310283prebade
prebake1539093prebake
prebook1557523prebook
precast11314853precast
precava1445093precava
precheck2144153precheck
precook1577803precook
predate10616893predate
predawn1335353predawn
predict12315323predict
predusk1443773predusk
preenact12410183preenact
prefab1336243prefa_b
prefabs1435163prefabs
prefaced1638423prefaced
prefacer1537983prefacer
prefaces15311063prefaces
prefade1339013prefade
prefect141011073prefect
prefrank1764233prefrank
pregame1239553pregame
prelate9519693prelate
prelaw1139103prela_w
prelect111013833prelect
premade12311443premade
preman104117453prema_n
prename11412643prename
prep86427673prep___
prepackage2152153prepackage
prepacking2145773prepacking
prepared132210873prepared
preparer12169643preparer
prepares122014163prepares
prepaste12139083prepaste
prepaved16177233prepaved
prepaves15189193prepaves
prepill1147583prepill
preplaced1676483preplaced
preplaces1578753preplaces
preplan1149953preplan
preplans1249613preplans
preplant12712913preplant
prepped11329903prepped
preppie1058093preppie
preppy1235523prep_py
prepreg12165963prepreg
preprice1488873preprice
preps96220693prep__s
prepuces1438583prepuces
prepunch1743643prepunch
prepupa1064023prepupa
presa74319043presa__
presage10312293presage
presale9416353presale
presoak1348453presoak
pretape113511623pretape
pretax152310193preta_x
prevail1238243prevail
prewar114712583prewa_r
prewarm14479613prewarm
prewarn124410153prewarn
prewash1535213prewash
prework164210913prework
prick134317503pr__ick
primacy1635603primacy
privacy1744233privacy
propane112716153propane
rack106234883_r__ack
reach105123883_re_ach
react74634333_re_act
rebeck14419913_rebeck
reck106130563_re__ck
recock145112723_recock
redact9419043_redact
redock134311543_redock
reface113616353_reface
relace83122153_relace
relock124713523_relock
remark123512373_remark
repacked17188743_repacked
repaid94716323_repaid
repair84011463_repair
repand95316063_repand
reparks13249513_reparks
repass84114703_repass
repast83520633_repast
repatch1435843_repatch
repave114813873_repave
repay104818453_repa_y
repays113813973_repays
reperk122511773_reperk
replace113214283_replace
reracks132310533_reracks
respace11310913_respace
restack1339433_restack
retacks132210713_retacks
retrack131310723_retrack
shoepack1943783shoepack
tieback1547103tieback
track114823013tr__ack
trepan82511673trepa_n
trepang10257293trepang
trepans92311593trepans
tripacks1664893tripacks
unpack1457833_unpack
upreach1444693upre_ach
wrack145413883wr__ack
wreak125513273wre_a_k
wreck144611043wre__ck

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271706.23621492.5
3Display Results1701700.0602833.3
 (SQL Overall)1786911706.68626726.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.