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

182 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
presenting13101302(None) 
precenting151012151precenting
presetting131010831presetting
preventing161210261preventing
resenting102619291_resenting
copresenting1754942copresenting
preening113115842pre_en_ing
preheating16310722preheating
prelecting15310162prelecting
preselling1338692preselling
presentient1348322presentient
presentism1447242presentism
presentist12410092presentist
preserving1637362preserving
presettling1444452presettling
presifting1638082presifting
presorting1339982presorting
pretending1438612pretending
pretesting131810682pretesting
pretexting20206972pretexting
prosecting15189812prosecting
relenting102716772_relenting
repenting122316552_repenting
representing1555132representing
rerenting102617662_rerenting
reseating102421532_reseating
resecting122816482_resecting
resending112313362_resending
resetting102816292_resetting
absenting1236993_absenting
assenting1038163_assenting
besetting12268423_besetting
breveting1536263breve_ting
brevetting1644333brevetting
cementing1438763_cementing
consenting13313223consenting
cresting114017043cres__ting
dementing13311043_dementing
deserting11713143_deserting
dissenting121310293dissenting
fermenting1646823fermenting
frequenting2443273frequenting
freshening1744773freshen_ing
greening103112533gre_en_ing
greenling1136753gre_enling
greenwing1434693gre_enwing
greeting103112353gre_e_ting
orienting1038723or_ienting
pacesetting1652633pacesetting
parenting12611583p_arenting
patenting1248943p_atenting
peening103318303p_e_en_ing
perfecting1847513perfecting
permeating1539923permeating
perpending1646683perpending
persecuting1643833persecuting
persisting1346653persisting
personating1447673personating
perverting1646623perverting
pigmenting1653713pigmenting
praelecting1644533praelecting
preacting142412533pre_acting
prebinding1696163prebinding
precasting15169833precasting
preceding15129363prece_ding
precessing1598743precessing
precutting1546423precutting
predating13514653pre_dating
predestine1349323predestine
predicting1649873predicting
preediting1447933preediting
preeing103817673pre_e__ing
preelecting1646473preelecting
preempting1745393preempting
preenacting16125373pre_enacting
preerecting1646143preerecting
preferring1645623preferring
prefunding1745233prefunding
preinserting1544173preinserting
preopening1546243preopen_ing
prepasting15168883prepasting
preplanting1645933preplanting
preprinting1647413preprinting
prerinsing1347643prerinsing
presaging1339393pres_aging
prescinding1744853prescinding
prescoring1547433prescoring
preselecting1744293preselecting
present94022733present___
presented12311633present_ed
presentee11411863present_ee
presentees1247923presentees
presentence1546393presentence
presentencing1852503presentencing
presenter11311643present_er
presenters1239863presenters
presentiment1654453presentiment
presentisms1555213presentisms
presently1449063present_ly
presentment1555673presentment
presents103315643present__s
preshaping1845423preshaping
preshowing1944473preshowing
presiding13510903pres_iding
preslicing1546363preslicing
presoaking1736253presoaking
presolving1644363presolving
pressing112516443pres__sing
pressuring1346513pressuring
prestoring13310303prestoring
presuming1437663pres_uming
pretasting13239283pretasting
pretelling1338133pretelling
pretreating1448893pretreating
preuniting1347303preuniting
prevention1549173prevention
preventions1648533preventions
preventive1847543preventive
preweaning1645633preweaning
prewriting1647243prewriting
priesting1239483pr_iesting
printing113216083pr__inting
prisoning1237643prison_ing
projecting22177243projecting
propending1646143propending
prosecuting1645023prosecuting
proselyting1743903proselyting
prospecting1845853prospecting
protecting151910213protecting
protending1446813protending
protesting131910253protesting
recanting122414823_recanting
redenying1437783_redenying
reesting93118273_re_esting
refecting152413353_refecting
refencing15188853_refencing
reheating132314913_reheating
rejecting192211153_rejecting
relending112412023_relending
reletting102713943_reletting
remeeting12311433_remeeting
remelting12311703_remelting
remending132311313_remending
reminting122315103_reminting
renesting102514703_renesting
renting84026853_r__enting
repeating122618983_repeating
resealing102115673_resealing
reseeding112410493_reseeding
reseeing92412623_rese_eing
reseeking14208493_reseeking
reseizing19311233_reseizing
reselling102213833_reselling
resentive12410723_resentive
reserving131110643_reserving
resettling1135893_resettling
resewing122712263_rese_wing
resifting133512093_resifting
resinating11313733_resinating
resining92919553_resin_ing
resisting103215313_resisting
resiting93521123_res_iting
resitting103414873_resitting
reslating102516993_reslating
resmelting1337263_resmelting
resonating11311263_resonating
resorting10614613_resorting
respecting1549883_respecting
respiting121912863_respiting
restating102319413_restating
resting85031183_res__ting
resulting10311083_resulting
retesting102614603_retesting
retinting102215253_retinting
revenging1438083_revenging
reverting132315133_reverting
revesting132814123_revesting
revetting132912633_revetting
rewetting132710443_rewetting
trisecting1345503trisecting
unrelenting1244423unrelenting
wresting123811833wres__ting

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.406440125.6
2DLD Change Limit1406031826.76620780.8
3Display Results1821820.0931957.0
 (SQL Overall)1786911827.26524596.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.