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

121 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
precools123770(None) 
precooks1656761precooks
precool1139011precool_
preboils1267292preboils
prebooks1656302prebooks
precious12310592precious
precodes13711572precodes
precook1577802precoo_k
precooled1446362precooled
preschools1753832preschools
recoals94214622_recoals
recoils93814872_recoils
recooks134711232_recooks
retools73411022_retools
befools1236433_befools
cools75632633___cools
creosols1045723creosols
cresols939653cre_sols
dewools1145593_dewools
drools74412813dr__ools
erectors103514263erectors
overcools1476773overcools
percoids1339663percoids
petrols92913083p_etrols
peyotls1233633p_eyotls
phenols1238103phe_nols
piccolos1444133piccolos
pools74427703p___ools
prebills1237293prebills
preboil1148953preboil_
prebook1557523preboo_k
preboom1348253preboo_m
precasts1239453precasts
precedes13310713precedes
precents123015043precents
precepts14268893precepts
precess11310863prec_ess
prechill1546193prechill
prechills1645123prechills
prechoose16105633prechoose
prechooses17116403prechooses
prechose15129773prechose
precipes143212213precipes
precis103416703prec__is
precises123218333precises
precocious1644743precocious
precode12311853prec_ode
precoded1438863precoded
precooked1844993precooked
precooker1744123precooker
precookers1843063precookers
precooling1545963precooling
precoup1336123prec_oup
precures12312903precures
precuts111710473prec_uts
prefocus1544743prefocus
preforms1537403preforms
preloads1157513preloads
premold1247863pre_mold
premolds1345843premolds
premolt11312073pre_molt
prenoon9310043prenoo_n
preops104911943pre__ops
prequels1934833prequels
preschool1643933preschool_
prescores133912173prescores
presells1058283presells
preshows16267023preshows
presoaks1436603presoaks
presold1059603pre_sold
presorts105311683presorts
pressors103212693pressors
prestos93716083presto_s
pretells1047333pretells
pretold1049083pre_told
pretors9316813pre_tors
pretzels1934033pretzels
prevails1337663prevails
previous1337823previous
preworks17599013preworks
proctors12311513proctors
proofs114511683pr__oofs
protocols1347203protocols
prowls115511083pr__owls
puccoons1443403puccoons
racoons93912433_racoons
reboils94111723_reboils
rebooks134010513_rebooks
reboots93512093_reboots
recalls92613623_recalls
reckons13269653_reckons
recoal84117973_recoal_
recoats92616643_recoats
recocks154711463_recocks
recodes102918633_recodes
recoil84016723_recoil_
recoins94019243_recoins
recolor978693_recolor
recolors1078813_recolors
recombs1336753_recombs
recons84922993_rec_ons
recook125513923_recoo_k
records105213923_records
recorks134813023_recorks
recoups1188843_recoups
recross989833_recross
rectors93520523_rectors
rectos85718783_recto_s
regosols944323_regosols
relooks114010723_relooks
reoils64516873_re_oils
repolls939053_repolls
rerolls739943_rerolls
reroofs1037943_reroofs
reschools1444083_reschools
respools1036253_respools
retool63914483_retool_
subcools1245753subcools
supercools14106183supercools
trefoils1145303trefoils
tremolos1046043tremolos

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.406440125.6
2DLD Change Limit1461621217.86018595.7
3Display Results1211210.0462630.4
 (SQL Overall)1786911218.31221498.0
 
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.