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 “leafletting” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

102 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
leafletting154198(None) 
leafleting1442891leafle_ting
befretting1644793be_fretting
deflecting1736503de_flecting
eyeletting1442873_eyeletting
leafletted1441973leaflett_ed
reallotting1243673reallotting
reflecting1638823re_flecting
reletting102713943re__letting
tabletting1344093_tabletting
abetting1158294__a_betting
affecting1845234__affecting
alerting91312384__a_lerting
allotting1046504__allotting
bassetting1344634_bassetting
befitting15236624be_f_itting
befleaing1544024be_fle_aing
beflecking2243034be_flecking
begetting13186584be__getting
besetting12268424be__setting
bloodletting1661334bloodletting
clearcutting175934clearcutting
deadlifting1742504deadlifting
deafening1476274deaf_e_ning
defalcating1844344defalcating
defatting1436104de_f_atting
defeating142311974de_f_eating
defecting162510224de_f_ecting
deflating142610714de_fl_ating
defleaing1444744de_fle_aing
deleting103314424de__le_ting
depleting1378194de_ple_ting
deselecting1544474deselecting
effecting1845584_e_ffecting
electing112113784_e__lecting
englutting1242724_englutting
facetting1535284_fa_cetting
fetting113517874___f_etting
flatting123511254___flatting
fleeting122910324___fleeting
flitting123010884___flitting
fretting122711524___fretting
galleting1137634_galle_ting
gazetting2043244_ga_zetting
genuflecting1961254genuflecting
inflecting1646314_inflecting
inletting1087874__inletting
lamenting1237694l_a_menting
laureating1146394l_aureating
leadening1176734lea_de_ning
leafing113313584leaf____ing
leaflet10199744leafle_t___
leafleted1342894leafle_t_ed
leafleteer1351374leafle_teer
leafleteers1461254leafleteers
leafleter1242554leafle_t_er
leafleters1342434leafle_ters
leaflets11244814leafle_t__s
leaguering1243814league_ring
leathering1488684leathe_ring
leavening1365974lea_ve_ning
leftwing1532974le_f__twing
letting83218534____letting
neglecting1444544ne_glecting
offsetting1742334_offsetting
overletting1548014overletting
palleting1238744_palle_ting
pargetting1444944_pargetting
pelleting1237954pe_lle_ting
perfecting1847514perf_ecting
praelecting1644534praelecting
preallotting1551994preallotting
reaccenting1665014reaccenting
reaccepting1863894reaccepting
readmitting1544054readmitting
realtering1139474rea_ltering
rearresting1245964rearresting
reasserting1246154reasserting
reelecting1338784re_electing
refecting152413354re_f_ecting
refitting132811124re_f_itting
reflating132514714re_fl_ating
reflexing2035934re_fle_xing
refloating14198324re_floating
regretting1237784re_gretting
relenting102716774re__lenting
replotting1357044re_plotting
reselecting1446024reselecting
resetting102816294re__setting
resplitting1444944resplitting
revetting132912634re__vetting
rewetting132710444re__wetting
rouletting1144754_rouletting
safetying1643074_saf_etying
sealifting1444634sea_lifting
selecting12310534se__lecting
subletting1346274_subletting
tableting1236354_table_ting
telnetting1143884te_lnetting
unaffecting2052164unaffecting
valeting1238854_va_le_ting
wadsetting1542914_wadsetting

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191028.73617035.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911029.20219418.7
 
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.