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

109 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
pretelling133813(None) 
preselling1338691preselling
retelling102112491_retelling
crenelling1345682crenelling
foretelling1543592foretelling
prebilling1595412prebilling
pretending1438612pretending
pretesting131810682pretesting
pretexting20206972pretexting
propelling1556932propelling
rebelling122111162_rebelling
refelling132211312_refelling
repelling122312752_repelling
reselling102213832_reselling
retellings11244652_retellings
revelling132412552_revelling
bevelling15227453_bevelling
creeling113513363cre_e_ling
creneling1247733crene_ling
drivelling1543983drivelling
farewelling1842623farewelling
ferrelling1445063ferrelling
gravelling1565213gravelling
greenling1136753gre_enling
grovelling1554163grovelling
gruelling1155603gr_uelling
hostelling1446163hostelling
jewelling2034833_jewelling
kernelling1584143kernelling
levelling13206973_levelling
metalling1249593_metalling
outtelling11107133outtelling
panelling1239073p_anelling
parcelling1546173parcelling
pedalling1346663p_edalling
peeling102919873p_e_e_ling
perilling12410003p_erilling
petering112516813p_ete_ring
pettling1168213p_et_tling
pistolling1345353pistolling
pommelling1743613pommelling
prattling1246303prat_tling
preboiling1546403preboiling
preceding15129363prece_ding
precenting151012153precenting
precessing1598743precessing
prechilling1943743prechilling
precooling1545963precooling
predrilling1543673predrilling
preeing103817673pre_e__ing
preening113115843pre_e_ning
preferring1645623preferring
prefiling1549533pre_filing
preheating16310723preheating
prelecting15310163prelecting
premolding1644673premolding
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
presettling1444453presettling
presolving1644363presolving
pretaping1439133pret_aping
pretasting13239283pretasting
pretell938243pretell___
pretells1047333pretell__s
pretreating1448893pretreating
prettying1536043pret_tying
pretyping1764943pret_yping
prevailing1656723prevailing
prevaluing1644273prevaluing
preventing161210263preventing
preweaning1645633preweaning
prilling113413413pr__illing
protecting151910213protecting
protending1446813protending
protesting131910253protesting
pummelling1743163pummelling
ravelling13269243_ravelling
rebilling12228833_rebilling
recalling122211903_recalling
reedling102414273_re_edling
reeling83126863_re_e_ling
refalling132010423_refalling
refeeling13229313_refeeling
refilling13299333_refilling
refuelling1474973_refuelling
reheeling13218263_reheeling
remelting12311703_remelting
repealing122513543_repealing
repolling122110203_repolling
rerolling102210373_rerolling
resealing102115673_resealing
respelling1347973_respelling
retailing103214733_retailing
retallying1464703_retallying
reteaming122110443_reteaming
retearing102214253_retearing
retesting102614603_retesting
retiling93319483_ret_iling
retitling1039773_retitling
retooling1039093_retooling
revealing132611883_revealing
reveling123117083_reve_ling
rewelding1436913_rewelding
rowelling1366993_rowelling
telling83321083___telling
tramelling1346373tramelling
travelling1456533travelling
trowelling1484913trowelling

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 Filter1786911406030.513348325.5
2DLD Change Limit1406031096.53321522.0
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.09225196.1
 
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.