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

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

99 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
prebooks165630(None) 
prebook1557521prebook_
precooks1656761precooks
rebooks134010511_rebooks
ebooks12358332__ebooks
preboils1267292preboils
prebooked1863912prebooked
preboom1348252preboo_m
precook1577802precook_
precools1237702precools
presoaks1436602presoaks
preworks17599012preworks
rebook125213202_rebook_
reboots93512092_reboots
recooks134711232_recooks
relooks114010722_relooks
bluebooks1743153bluebooks
books115729713___books
brooks125813883br__ooks
casebooks1743793casebooks
codebooks1843693codebooks
crooks124914413cr__ooks
datebooks1643113datebooks
daybooks1843983daybooks
ebook114510803__ebook_
eyehooks1842833eyehooks
forebooms1645333forebooms
freeboots1444043freeboots
hornbooks1843813hornbooks
lawbooks1743743lawbooks
logbooks1544023logbooks
nonbooks1446123nonbooks
notebooks1543123notebooks
overbooks1855873overbooks
passbooks1743163passbooks
playbooks2043373playbooks
pothooks1746053pothooks
prebake1539093preb_ake
prebakes1639013prebakes
prebends13347883prebends
prebids12399883preb_ids
prebills1237293prebills
prebinds13357733prebinds
prebless1236823prebless
preboard1338263preboard
preboards1446423preboards
preboil1148953preb_oil
prebooking1944073prebooking
prebound1345893prebound
prebuys1444393preb_uys
precious12310593precious
precodes13711573precodes
precooked1844993precooked
precooker1744123precooker
precookers1843063precookers
precool1139013precoo_l
predusks1543423predusks
prefocus1544743prefocus
preforms1537403preforms
preloads1157513preloads
premolds1345843premolds
prenoon9310043prenoo_n
preops104911943pre__ops
prepacks1836583prepacks
prerock1536723prerock_
preshows16267023preshows
presoak1348453presoak_
presorts105311683presorts
pressors103212693pressors
prestos93716083presto_s
pretors9316813pre_tors
previous1337823previous
prework164210913prework_
proofs114511683pr__oofs
pueblos1134843pueblo_s
purebloods1571723purebloods
rebecks15288013_rebecks
reblooms1244283_reblooms
reboils94111723_reboils
rebooked15226503_rebooked
reboot84119333_reboo_t
rebops10311433_reb_ops
rebores95319163_rebores
rebozos1835143_rebozos
recocks154711463_recocks
recook125513923_recook_
recorks134813023_recorks
redocks14409933_redocks
relocks134411293_relocks
relook104813743_relook_
reroofs1037943_reroofs
resoaks1148973_resoaks
retook104313443_retook_
retools73411023_retools
reworks145113603_reworks
rheboks1634003rheb_oks
rooks95325043_r__ooks
wordbooks1943663wordbooks
workbooks1743413workbooks

Search took 9 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.500357382.0
2DLD Change Limit146162997.75018859.6
3Display Results99990.0462152.2
 (SQL Overall)178691998.29621539.4
 
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.