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

136 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
precool113901(None) 
precook1577801precook
precools1237701precools
preboil1148952preboil
prebook1557522prebook
preboom1348252preboom
precode12311852precode
precooks1656762precooks
precooled1446362precooled
precoup1336122precoup
prenoon9310042prenoon
preschool1643932preschool
recoal84117972_recoal
recoil84016722_recoil
recook125513922_recook
retool63914482_retool
befool1137713_befool
cool66940493___cool
creosol946053creosol
cresol8310213cre_sol
dewool1047403_dewool
drool65416103dr__ool
erector93513813erector
overcool1376783overcool
percoid12312313percoid
petrol82714063p_etrol
peyotl1146233p_eyotl
phenol1149253phe_nol
piccolo1354403piccolo
pool65835953p___ool
preanal9310713preanal
prebill1138803prebill
preboils1267293preboils
prebooks1656303prebooks
precast11314853precast
precava1445093precava
precaval1544723precaval
precede1239653precede
precent113520263precent
precept133112513precept
precess11310863precess
prechill1546193prechill
prechoose16105633prechoose
prechose15129773prechose
precious12310593precious
precipe133012123precipe
precis103416703prec_is
precise113518173precise
precocial1547503precocial
precoded1438863precoded
precodes13711573precodes
precoital1347273precoital
precooked1844993precooked
precooker1744123precooker
precooling1545963precooling
precure11312553precure
precut102016533prec_ut
precuts111710473precuts
predial103815413predial
preform1439613preform
preload1049813preload
premeal11310523premeal
premold1247863premold
premolt11312073premolt
premoral1249713premoral
preop94715873pre__op
preops104911943pre_ops
preoral9312673preoral
prepill1147583prepill
prequel1836343prequel
preriot9316413preriot
prerock1536723prerock
preschools1753833preschools
prescore124812373prescore
presell939303presell
preshow15237413preshow
presoak1348453presoak
presold1059603presold
presong1039843presong
presort95219543presort
pressor93512883pressor
presto84216203presto_
prestos93716083prestos
pretell938243pretell
pretold1049083pretold
pretor8315753pre_tor
pretors9316813pretors
pretzel1835143pretzel
prevail1238243prevail
prework164210913prework
preworn124711223preworn
proctor11310433proctor
proof105221533pr__oof
protocol1246473protocol
prowl105615123pr__owl
puccoon1343503puccoon
racoon83814473_racoon
reboil83814683_reboil
rebook125213203_rebook
reboot84119333_reboot
recall83815723_recall
reckon123010543_reckon
recoals94214623_recoals
recoat84024273_recoat
recock145112723_recock
recode93618713_recode
recoils93814873_recoils
recoin84320293_recoin
recolor978693_recolor
recomb1238873_recomb
recon75624243_rec_on
recons84922993_recons
recooks134711233_recooks
recopy1339043_recopy
record96117433_record
recork126315493_recork
recoup10810373_recoup
rectal84418133_rectal
recto74520803_recto_
rector84019753_rector
rectos85718783_rectos
regosol844883_regosol
relook104813743_relook
reoil55321183_re_oil
repoll8410793_repoll
reroll6412683_reroll
reroof9315003_reroof
reschool1344133_reschool
respool937643_respool
retook104313443_retook
retools73411023_retools
subcool1146233subcool
supercool1376523supercool
trefoil1066063trefoil
tremolo946513tremolo
uncool8610113_uncool

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.403443402.0
2DLD Change Limit1340271366.78319759.3
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.24924650.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.