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

113 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
prebook155752(None) 
prebooks1656301prebooks
preboom1348251preboom
precook1577801precook
rebook125213201_rebook
ebook114510802__ebook
preboil1148952preboil
prebooked1863912prebooked
precooks1656762precooks
precool1139012precool
prenoon9310042prenoon
prerock1536722prerock
presoak1348452presoak
prework164210912prework
rebooks134010512_rebooks
reboot84119332_reboot
recook125513922_recook
relook104813742_relook
retook104313442_retook
betook12439603_betook
bluebook1643393bluebook
book106836333___book
brook114717763br__ook
caretook1445173caretook
casebook1644453casebook
codebook1744113codebook
crook115217573cr__ook
datebook1543303datebook
daybook1744373daybook
ebooks12358333__ebooks
eyehook1743343eyehook
foreboom1546133foreboom
freeboot1345933freeboot
hornbook1744653hornbook
lawbook1644033lawbook
logbook1454513logbook
nonbook1346283nonbook
notebook1443603notebook
overbook1796323overbook
partook1337313partook
passbook1643283passbook
playbook1943463playbook
pothook1656883pothook
prebade12310283prebade
prebake1539093prebake
prebend12319443prebend
prebid113512843preb_id
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
preboard1338263preboard
preboils1267293preboils
prebooking1944073prebooking
prebound1345893prebound
prebuy1357423preb_uy
prebuys1444393prebuys
precode12311853precode
precooked1844993precooked
precooker1744123precooker
precools1237703precools
precoup1336123precoup
predusk1443773predusk
preform1439623preform
preload1049813preload
premold1247863premold
premolt11312073premolt
preop94715873pre__op
preops104911943pre_ops
prepack1757643prepack
preriot9316413preriot
preshow15237413preshow
presoaks1436603presoaks
presold1059603presold
presong1039843presong
presort95219543presort
pressor93512883pressor
presto84216203presto_
prestos93716093prestos
pretold1049083pretold
pretor8315753pre_tor
pretors9316813pretors
preworks17599013preworks
preworn124711223preworn
proof105221533pr__oof
pueblo1035553pueblo_
pueblos1134843pueblos
pureblood1471943pureblood
rebeck14419913_rebeck
rebloom1145663_rebloom
rebody1238153_rebody
reboil83814683_reboil
rebooked15226503_rebooked
reboots93512093_reboots
rebop9313283_reb_op
rebops10311433_rebops
rebore86625653_rebore
reborn810016963_reborn
rebozo1737323_rebozo
rebozos1835143_rebozos
recock145112723_recock
recooks134711233_recooks
recork126315493_recork
redock134311543_redock
relock124713523_relock
relooks114010723_relooks
reroof9315003_reroof
resoak10311093_resoak
retool63914483_retool
rework136619793_rework
rhebok1534613rheb_ok
rook85532033_r__ook
wordbook1844063wordbook
workbook1643743workbook

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271136.98619185.1
3Display Results1131130.0432627.9
 (SQL Overall)1786911137.43524033.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.