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

161 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
presetting13101083(None) 
presenting131013021presenting
presettling1444451presettling
resetting102816291_resetting
besetting12268422_besetting
brevetting1644332brevetting
pacesetting1652632pacesetting
precenting151012152precenting
precutting1546422precutting
preheating16310722preheating
prelecting15310162prelecting
preselling1338692preselling
preserving1637362preserving
presifting1638082presifting
presorting1339982presorting
pretesting131810682pretesting
pretexting20206972pretexting
preventing161210262preventing
prosecting15189812prosecting
reletting102713942_reletting
reseating102421532_reseating
resecting122816482_resecting
resenting102619292_resenting
resettling1135892_resettling
resitting103414872_resitting
revetting132912632_revetting
rewetting132710442_rewetting
bassetting1344633bassetting
begetting13186583_begetting
besotting12256873_besotting
breveting1536263breve_ting
copresenting1754943copresenting
cresting114017043cres__ting
deserting11713143_deserting
eyeletting1442873eyeletting
fretting122711523fr__etting
greeting103112353gre_e_ting
insetting1079283_insetting
missetting13107903missetting
offsetting1742333offsetting
oversetting1548813oversetting
pargetting1444943pargetting
perfecting1847513perfecting
permeating1539923permeating
permitting1546303permitting
persecuting1643833persecuting
persisting1346653persisting
perverting1646623perverting
pestering122315663p_estering
pestling111010253p_es_tling
petting103720953p___etting
pipetting1435513p_ipetting
pirouetting1442693pirouetting
poussetting1452813poussetting
praelecting1644533praelecting
preacting142412533pre_acting
precasting15169833precasting
preceding15129363prece_ding
precessing1598743precessing
predating13514653pre_dating
predestine1349323predestine
predicting1649873predicting
preediting1447933preediting
preeing103817673pre_e__ing
preelecting1646473preelecting
preempting1745393preempting
preening113115843pre_e_ning
preerecting1646143preerecting
preferring1645623preferring
preinserting1544173preinserting
prepasting15168873prepasting
presaging1339393pres_aging
prescoring1547433prescoring
preselecting1744293preselecting
presentient1348323presentient
presentism1447243presentism
presentist12410093presentist
presettle1145943presett_le
presettled1344083presettled
presettles1245023presettles
preshaping1845423preshaping
preshowing1944473preshowing
presiding13510903pres_iding
preslicing1546363preslicing
presoaking1736253presoaking
presolving1644363presolving
pressing112516443pres__sing
pressuring1346513pressuring
prestoring13310303prestoring
presuming1437663pres_uming
pretasting13239283pretasting
pretelling1338133pretelling
pretending1438613pretending
pretreating1448893pretreating
prettying1536043pre_ttying
preuniting1347303preuniting
preweaning1645633preweaning
prewriting1647243prewriting
priesting1239483pr_iesting
projecting22177243projecting
prosecuting1645023prosecuting
proselyting1743903proselyting
prospecting1845853prospecting
protecting151910213protecting
protesting131910253protesting
rebutting1237523_rebutting
recutting1239483_recutting
reesting93118273_re_esting
refecting152413353_refecting
refitting132811123_refitting
regretting1237783_regretting
reheating132314913_reheating
rejecting192211153_rejecting
relenting102716773_relenting
remeeting12311433_remeeting
remelting12311703_remelting
remitting122412623_remitting
renesting102514703_renesting
repeating122618983_repeating
repenting122316553_repenting
repotting12511123_repotting
representing1555133representing
rerenting102617663_rerenting
resealing102115673_resealing
reseeding112410493_reseeding
reseeing92412623_rese_eing
reseeking14208493_reseeking
reseizing19311233_reseizing
reselling102213833_reselling
resending112313363_resending
reserving131110643_reserving
resewing122712263_rese_wing
resifting133512093_resifting
resisting103215313_resisting
resiting93521123_res_iting
resittings11264553_resittings
reslating102516993_reslating
resmelting1337263_resmelting
resorting10614613_resorting
respecting1549883_respecting
respiting121912863_respiting
respotting1347113_respotting
restating102319413_restating
resting85031183_res__ting
restring91518783_res_tring
resulting10311083_resulting
retesting102614603_retesting
retting83425883_r__etting
reverting132315133_reverting
revesting132814123_revesting
rivetting13256413_rivetting
russetting1184253russetting
setting83621393___setting
trendsetting1451393trendsetting
trisecting1345503trisecting
typesetting1752223typesetting
unsetting1088993_unsetting
upsetting1275563_upsetting
wadsetting1542913wadsetting
wresting123811833wres__ting
wrestling1336063wres_tling

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 Filter1786911406030.1561145455.1
2DLD Change Limit1406031617.86017888.4
3Display Results1611610.0931731.2
 (SQL Overall)1786911618.10922036.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.