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

114 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
prerock153672(None) 
prebook1557522prebook
precook1577802precook
prepack1757642prepack
prerace11414122prerace
presoak1348452presoak
prework164210912prework
recock145112722_recock
redock134311542_redock
relock124713522_relock
rerack122513162_rerack
armlock1544313armlock
arrack121110253ar_rack
bedrock1645643bedrock
bemock1636173_bemock
brock136017073__brock
caprock1736813caprock
crock135921993__crock
defrock1744643defrock
derrick1435803derrick
dreck124812803dre__ck
firelock1744823firelock
forelock1745593forelock
frock145314653__frock
laverock1743543laverock
lavrock1644223lavrock
mudrock1644353mudrock
outrock1339303outrock
paddock17104733paddock
padlock1665813padlock
peacock1745143peacock
peck125730683p_e__ck
perch124518833p_er_ch
perk106232843p_er__k
peroxy1838253p_eroxy
perron83216623perro_n
perrons93115483perrons
petcock1744603petcock
pibroch1643803pibroch
piddock17103653piddock
pierce104010393pier_ce
pierogi1054723pierogi
pock126129293p___ock
pollock1546843pollock
preach133613923pre_ach
preact103220393pre_act
preboil1148953preboil
prebooks1656303prebooks
preboom1348253preboom
precheck2144153precheck
precode12311853precode
precooks1656763precooks
precool1139013precool
precoup1336123precoup
predict12315323predict
predusk1443773predusk
preerect1259273preerect
preface14510923preface
prefect141011073prefect
prefocus1544743prefocus
preform1439613preform
prefrank1764233prefrank
prefroze2264673prefroze
prelacy1437583prelacy
prelect111013833prelect
preload1049813preload
premold1247863premold
premolt11312073premolt
prenoon9310043prenoon
preop94715873pre_o_p
preops104911943pre_ops
preoral9312673preoral
prepacks1836583prepacks
preprice1488873preprice
prepuce1337833prepuce
preriot9316413preriot
presoaks1436603presoaks
presold1059603presold
presong1039843presong
presort95219543presort
pretold1049083pretold
pretor8315753preto_r
pretors9316813pretors
preworks17599013preworks
preworn124711223preworn
prick134317503p__rick
princock1842833princock
rebeck14419913_rebeck
rebook125213203_rebook
reck106130563_re__ck
recocks154711463_recocks
recook125513923_recook
recork126315493_recork
redocks14409933_redocks
relocks134411293_relocks
relook104813743_relook
repack142412163_repack
reracks132310533_reracks
reroll6412683_reroll
reroof9315003_reroof
rerose63320843_rerose
resoak10311093_resoak
restock1338673_restock
retack122612823_retack
retook104313443_retook
retrack131310723_retrack
rework136619793_rework
rimrock1544383rimrock
rock105735183___rock
sherlock1744243sherlock
traprock1643483traprock
trock114817603__trock
unfrock1674633unfrock
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.406440125.6
2DLD Change Limit1340271146.21621561.6
3Display Results1141140.0333454.5
 (SQL Overall)1786911146.65526850.6
 
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.