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

134 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
prefreezing264287(None) 
refreezing2344411_refreezing
deepfreezing286853deepfreezing
freezing21308323___freezing
nonfreezing2452383nonfreezing
precreasing1645703precreasing
preerecting1646143preerecting
preferring1645623pref_erring
prefranking2143313prefranking
prefreeze2342093prefreez__e
prefreezes2441993prefreez_es
preordering15124303preordering
prescreening1752873prescreening
pretreating1448893pretreating
rebreeding1445423_rebreeding
refeeding14247933_ref_eeding
refeeling13229313_ref_eeling
refereeing1444673_refereeing
refreshing1746063_refreshing
regreening1246033_regreening
regreeting1237343_regreeting
subfreezing2661963subfreezing
unfreezing2343343_unfreezing
befretting1644794_befretting
breezing20368134___breezing
decreeing1335524_decree_ing
feezing204610164___f_eezing
forefeeling1842454foref_eeling
freeing113713914___free_ing
overfeeding1945914overfeeding
perfecting1847514perf_ecting
prealtering1446174prealtering
prearming14139224prear__ming
preaverring1743244preaverring
preblessing1643734preblessing
preceding15129364pre__ceding
precenting151012154pre_centing
precessing1598744pre_cessing
prechecking2543074prechecking
precleaning1644264precleaning
preclearing1645104preclearing
preconizing2548234preconizing
predrilling1543674predrilling
predrying1645344predr__ying
preeing103817674p___ree_ing
preelecting1646474preelecting
preening113115844p___reening
prefabbing2042584pref_abbing
prefacing17118744pref__acing
prefading16149034pref__ading
prefiguring1842934prefiguring
prefiling1549534pref__iling
prefiring1559074pref__iring
prefixing2246784pref__ixing
prefocusing1953134prefocusing
preforming1846234pref_orming
prefrozen2352844prefr_ozen_
prefunding1745234pref_unding
prehardening1952584prehardening
preheating16310724pre_heating
prelecting15310164pre_lecting
premarketing2152564premarketing
premiering1547244pre_miering
preopening1546244pre_opening
prepricing1746734prepr_icing
preprinting1647414preprinting
prereleasing1552904pre_releasing
prerinsing1347644pre_rinsing
preselling1338694pre_selling
presenting131013024pre_senting
preserving1637364pre_serving
presetting131010834pre_setting
prestressing1583974prestressing
presurveying2151354presurveying
pretelling1338134pre_telling
pretending1438614pre_tending
pretesting131810684pre_testing
pretexting20206974pre_texting
pretraining1446504pretraining
pretrimming1843034pretrimming
preventing161210264pre_venting
previewing1943674pre_viewing
preweaning1645634pre_weaning
prewrapping1842394prewrapping
prewriting1647244prewr_iting
proceeding1644674pr_oceeding
procreating1647694procreating
professing16106624prof_essing
proffering1943774prof_fering
profiteering1852134profiteering
progressing1545774progressing
proofreading1951674proofreading
pureeing1137274p__uree_ing
recreating131214584_recreating
redeeming1337364_re_deeming
redreaming1446444_redreaming
redressing1247824_redressing
reerecting1339974_reerecting
refecting152413354_ref_ecting
refelling132211314_ref_elling
refencing15188854_ref_encing
referencing1744494_referencing
referring1338034_ref_erring
reflecting1638824_reflecting
reflexing2035934_ref_lexing
reforesting1546194_reforesting
refracting1638734_refracting
refraining1437264_refraining
reframing1538624_refr_aming
refreeze2063264_refreez__e
refreezes2153444_refreez_es
refreshening1952424_refreshening
refronting1437274_refronting
refrying15278904_refr__ying
refueling13227974_ref_ueling
refuelling1474974_refuelling
regressing1248144_regressing
regretting1237784_regretting
reheeling13218264_re_heeling
remeeting12311434_re_meeting
reordering1266214_reordering
repressing13310394_repressing
reprieving1644894_reprieving
rereading111212714_re_reading
rerenting102617664_re_renting
rescreening1444084_rescreening
reseeding112410494_re_seeding
reseeing92412624_re_see_ing
reseeking14208494_re_seeking
reseizing19311234_re_seizing
retreading12128484_retreading
retreating111414774_retreating
retrieving1445294_retrieving
unfreeing1345104_unfree_ing

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 Limit1488191348.72017066.4
3Display Results1341340.0602233.3
 (SQL Overall)1786911349.20019422.9
 
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.