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

136 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
recleaned123658(None) 
precleaned1543791precleaned
cleaned103512002__cleaned
precleared1544102precleared
recaned102817202rec__aned
reclean938522reclean__
recleans1037512reclean_s
reclined113613602recl_ined
recreated12412532recreated
relearned1035632re_learned
released9310242re_leased
reloaned939722re_loaned
repleaded1336282repleaded
uncleaned1237172uncleaned
becloaked1843733becloaked
beclowned1743243beclowned
befleaed1454653beflea_ed
beleaped1336103be_leaped
bemeaned1335783be_meaned
cleaner93712303__cleaner
cleansed11395933__cleansed
cleared103612463__cleared
cleated103417843__cleated
cleaved134010483__cleaved
deceased1247713dec_eased
decerned1237263dec_erned
declared1248743decl_ared
declawed1545923decl_awed
declined123910883decl_ined
decreased1345453decreased
defleaed1344943deflea_ed
deleaded1148333de_leaded
deleaved1346573de_leaved
demeaned1237283de_meaned
deplaned1238653depl_aned
gleaned9349423__gleaned
leaned73422543___leaned
nucleated1247873nucleated
overcleaned1744703overcleaned
preclean1245893preclean__
precleans1344893preclean_s
precreased1544413precreased
realigned1145333realigned
reblend1036653reble_n_d
reblended1355203reblended
recane83022873rec__ane_
recanes93222263rec__anes
recanted112513513rec__anted
receded112713043rec_e_ded
received1437983rec_eived
recessed1139713rec_essed
rechanged1646853rec_hanged
rechecked2143973rechecked
rechewed1735633reche_wed
reckoned1546953rec_koned
reclad9311873recl_a__d
recladded1443673recladded
reclaimed1435543reclaimed
reclame11411063recl_ame_
reclames12310893recl_ames
reclasped1444863reclasped
recleaning1336753recleaning
recline94020493recl_ine_
recliner103211913recl_iner
reclines103718543recl_ines
reclothed1544593reclothed
recoaled113111783rec_oaled
recoated113416783rec_oated
recoined113614423rec_oined
reconned113610653rec_onned
recrated112918583rec_rated
recreance1346993recreance
recreances1446503recreances
recreancy1643783recreancy
recreant10311283recrean_t
recreants1146623recreants
recreate10313603recreate_
recreates11313343recreates
recrowned1564853recrowned
reddened1136423redde_ned
redheaded1545083redheaded
redlined103811233redl_ined
redreamed1345023redreamed
reearned948883re__earned
reelected1238313reelected
reelevated1445153reelevated
reflated123514293refl_ated
reflected1547983reflected
reflexed1975243refle_xed
refloated1347013refloated
regeared1039433re_geared
regelated1139723regelated
reglazed1935743regl_azed
regreened1145553regreened
reheated122415003re_heated
relaced103517213re_l_aced
reland75920433re_l_an_d
relanded102410463re_l_anded
related83327573re_l_ated
relaxed153312523re_l_axed
relayed113212753re_l_ayed
release7312763re_lease_
releaser839503re_leaser
releases8313343re_leases
relegated1139763re_legated
relend76116453re_le_n_d
relented92614943re_lented
relined85321933re_l_ined
reloaded1059103re_loaded
reopened1138503reope_ned
repealed113211873re_pealed
repeated113117443re_peated
replaced133211393repl_aced
replanned1235163replanned
replanted1248063repl_anted
replated112817513repl_ated
replayed14248623repl_ayed
replead10399003replea__d
repleader1245383repleader
repledged1443603repledged
replevied1574363replevied
replevined1643153replevined
rereleased1143493rereleased
rescreened1344123rescreened
resealed92713963re_sealed
reseated93220263re_seated
reslated93517523resl_ated
reteamed1138013re_teamed
retreaded1137053retreaded
retreated10312613retreated
revealed123211213re_vealed
reweaved1535953re_weaved
richened1435953riche_ned
secerned1136103sec_erned
uncleaner1144763uncleaner
uncleared1237543uncleared

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.1731032896.0
2DLD Change Limit1486411368.01618543.0
3Display Results1361360.0931462.4
 (SQL Overall)1786911368.28221575.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.