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

203 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
preceding1512936(None) 
precoding15109731precoding
receding122713761_receding
breeding123411842bre_eding
precedent1448872precedent
precenting151012152precenting
precessing1598742precessing
precising14413272precising
precluding1644172precluding
precuring1439422precuring
preeing103817672pre_e_ing
preening113115842pre_ening
prefading16149032prefading
preluding1337052preluding
presiding13510902presiding
pretending1438612pretending
proceeding1644672proceeding
recoding122213852_recoding
reeding94124132_re_eding
seceding12288562_seceding
acceding1446093_acceding
anteceding1443953anteceding
arcading1239763ar_cading
bleeding12359053ble_eding
breading123515463bre_ading
breeching17236473breeching
breedings13375763bre_edings
breezing20368133bre_ezing
breveting1536263breveting
brocading1556253brocading
ceding104014803___ceding
conceding1559343conceding
creeling113513363cre_eling
creeping133310103cre_eping
creneling1247733creneling
deciding132210833_deciding
decoding132410053_decoding
deeding103315123_de_eding
dreading113712803dre_ading
dreeing94311183dre_e_ing
erecting112415063erec_ting
exceeding2043493exceeding
feeding123515073_fe_eding
freckling1934703freckling
freeing113713913fre_e_ing
freezing21308323fre_ezing
grecizing2235723grecizing
greeing93613783gre_e_ing
greening103112533gre_ening
greeting103112353gre_eting
heeding123515063_he_eding
needing93214423_ne_eding
parceling1438443parceling
peching154513903p_ec_hing
pecking164017783p_ec_king
peeing94618083p_e_e_ing
peeking144414953p_e_eking
peeling102919873p_e_eling
peening103318303p_e_ening
peeping123615213p_e_eping
peering103520353p_e_ering
peeving135112243p_e_eving
pending114119773p_e_nding
perceiving1844663perceiving
perching163711633perc_hing
perpending1646683perpending
pervading1636303pervading
petering112516813p_etering
piecing12410453piec__ing
pleading123011443ple_ading
preaching172811163preaching
preacting142412533preacting
prearming14139223prearming
prebaking1838063prebaking
prebidding1783843prebidding
prebinding1696163prebinding
prebuying1734303prebuying
precasting15169833precasting
precede1239653preced__e
preceded1438293preced_ed
precedence1746113precedence
precedency2053693precedency
precedents1545723precedents
precedes13310713preced_es
precent113520263prece__nt
prechecking2543073prechecking
precleaning1644263precleaning
preclearing1645103preclearing
precooking1945043precooking
precooling1545963precooling
precreasing1645703precreasing
precutting1546423precutting
predating13514653predating
predefine1546173predefine
predrying1645343predrying
preedit10512463pre_edi_t
preediting1447933pre_editing
preedits1168763pre_edits
prefacing17118743prefacing
preferring1645623preferring
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prefunding1745233prefunding
preguiding1544493preguiding
preheating16310723preheating
prehiring1548383prehiring
prejudging2242803prejudging
prelecting15310163prelecting
preloading1446583preloading
premedic1546303premedi_c
premedics1645303premedics
premiering1547243premiering
premising14412413premising
premixing2157803premixing
premolding1644673premolding
preopening1546243preopening
preparing14311643preparing
prepaving1787233prepaving
prepaying1747973prepaying
prepping12309763pre_pping
presaging1339393presaging
prescinding1744853prescinding
prescoring1547433prescoring
preselling1338693preselling
presenting131013023presenting
preserving1637363preserving
presetting131010833presetting
pressing112516443pre_ssing
presuming1437663presuming
pretaping1439133pretaping
pretelling1338133pretelling
pretesting131810683pretesting
pretexting20206973pretexting
prettying1536043prettying
pretyping1764943pretyping
preventing161210263preventing
previewing1943673previewing
prevising15510873prevising
prevuing1457253pre_vuing
preweaning1645633preweaning
prewiring1547893prewiring
preying133114553pr__eying
pricing123417343pric__ing
pricking173212603pric_king
prickling1836533prickling
priding113317543pr__iding
princeling1544653princeling
proceedings1752133proceedings
processing15108183processing
procuring1437993procuring
prodding13189343pr_odding
propending1646143propending
protending1446813protending
providing1637963providing
pureeing1137273pure_e_ing
reacceding1644223_reacceding
readding11411363_readding
reading93327213_re_ading
recaning111416693_recaning
receiving1538993_receiving
recessing12611013_recessing
rechewing1836493_rechewing
reciting113118073_reciting
recking144319923_rec_king
recording131311623_recording
recusing112512883_recusing
redding103218513_re_dding
reding83825563_r__eding
reedings103510363_re_edings
reedling102414273_re_edling
reefing114016863_re_efing
reeking123318643_re_eking
reeling83126863_re_eling
reeving113717663_re_eving
refeeding14247933_refeeding
rekeying1637563_rekeying
relending112412023_relending
remedying1635143_remedying
remending132311313_remending
rending93924263_re_nding
reneging102111533_reneging
renewing121910713_renewing
rereading111212713_rereading
reseeding112410493_reseeding
reseeing92412623_reseeing
resending112313363_resending
resewing122712263_resewing
residing103015483_residing
reveling123117083_reveling
revering122918073_revering
rewedding1535093_rewedding
rewelding1436913_rewelding
screeding1336323scre_eding
seeding93719483_se_eding
speeding122810933spe_eding
spreading1339653spre_ading
superceding1755663superceding
treading103515333tre_ading
treeing83414303tre_e_ing
trending103012833tre_nding
weeding123815213_we_eding
wrecking18328153wrec_king

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 Filter1786911486410.420425454.8
2DLD Change Limit1486412038.22018082.8
3Display Results2032030.0932182.8
 (SQL Overall)1786912038.73320461.6
 
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.