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

186 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
reclean93852(None) 
preclean1245891preclean
recleans1037511recleans
clean75420412__clean
precleans1344892precleans
preclear1245422preclear
recheat12415932recheat
reclad9311872recl_ad
recleaned1236582recleaned
recreant10311282recreant
relearn747972re_learn
reloan6415692re_loan
replan83215822repl_an
replead10399012replead
unclean946972unclean
aeolian738623aeolian
archean1269123archean
becloak1545043becloak
beclown1435423beclown
beflea1147123beflea_
befleas1236973befleas
beleap10410283be_leap
bellman1137183bellman
bemean10410683be_mean
bioclean1243153bioclean
brechan1437223brec_han
cerulean1053773cerulean
clan65633923__cl_an
cleans85817053__cleans
clear76219053__clear
cleat76335063__cleat
decern91310953dec_ern
declaw1266703decl_aw
decuman1236573decuman
deflea1037443deflea_
defleas1147223defleas
delead84112343de_lead
demean9510563de_mean
eclat7523603_ecl_at
elan46734243_e_l_an
eolian6312593_eolian
glean65818203__glean
herculean1452113herculean
lactean956473lactean
lean46345243___lean
lectern937033lectern
lethean1037093lethean
melena81110473me_lena
nucleal946693nucleal
nuclear936233nuclear
nuclein966123nuclein
nucleon945553nucleon
ocean71212963_oc_ean
overclean14115263overclean
pecan91919033pec__an
pechan13511543pec_han
pecten102711103pecte_n
precleaned1543803precleaned
preclears1344373preclears
preplan1149953prepl_an
raglan73711503ragl_an
realer63528593reale_r
reales64934123reale_s
realest73322433realest
realgar834873realgar
realia6314593realia_
realign838763realign
rebegan1045953rebegan
reblend1036653reblend
reblent9614253reblent
recane83022873rec__ane
recant83228683rec__ant
recap95718023rec__ap
recce9514563recce__
recces10614913recce_s
recede95515533rec_ede
recent83630853rec_ent
recept103319073rec_ept
recess8314263rec_ess
recheats1339193recheats
recheck1835613recheck
rechew14310213reche_w
rechews1537293rechews
recital9412163recital
recked134821803recke_d
reckless14257973reckless
reckon123010543rec_kon
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasp1136643reclasp
recleaning1336753recleaning
recline94020493recline
recluse95210773recluse
recoal84117973rec_oal
recoat84024273rec_oat
recoin84320293rec_oin
recon75624243rec__on
recreance1346993recreance
recreancy1643783recreancy
recreants1146623recreants
recreate10313603recreate
recrown12257573recrown
recta74220263rec_ta_
rectal84418133rec_tal
recusal968673recusal
recusant1049463recusant
redan66125013re__dan
redden83613623redde_n
redear73515173re_dear
redhead1257053redhead
redleg839273redle_g
redlegs936823redlegs
redream10107913redream
reearn6612143re__earn
reedman1037723reedman
reelect911515633reelect
reeled74725533reele_d
reeler63822573reele_r
reelers73520273reelers
reflag1098083refl_ag
reflect123913713reflect
reflet94024233refle_t
reflets103513153reflets
reflew12389453refle_w
reflex16359513refle_x
refloat10310833refloat
reflown13316213reflown
regear73512743re_gear
reglet73724233regle_t
reglets83512983reglets
regreen8309043regreen
rehear93713223re_hear
reheat94423943re_heat
reland75920433re_l_and
relax124817803re_l_ax
relay84424673re_l_ay
relearns836303re_learns
relearnt849213re_learnt
release7312763re_lease
relend76116453re_lend
relent64431853re_lent
relet54749823re_le_t
relets64025673re_lets
relevant1149243re_levant
releve95116403re_leve
reliant7319243re_liant
relleno796463relleno
reload7413893re_load
reloans7313133re_loans
reman75730153re__man
reopen8311573reope_n
repeal84718283re_peal
repeat85127213re_peat
replans92814943repl_ans
replant93318533repl_ant
replay113412923repl_ay
repleads11357213repleads
repled93319783reple_d
replete92912993replete
replevin1365053replevin
replevy1533473replevy
reran57329103re__ran
reread71715433re_read
rescreen1046703rescreen
reseal64819643re_seal
reseat64131493re_seat
reseau64216213re_seau
reseen64318413re_seen
resewn9459813re_sewn
respeak1335933respeak
reteam83214533re_team
retear63115483re_tear
retread849003retread
retreat7317533retreat
reveal94115053re_veal
rewan85623663re__wan
rewear93012003re_wear
richen113812513riche_n
rifleman1343413rifleman
rouleau746823rouleau
secern81010223sec_ern
spelean937123spelean
teleman959573te_leman
teleran7510173te_leran
unclear936573unclear

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271866.82619634.8
3Display Results1861860.0632952.4
 (SQL Overall)1786911867.27924548.8
 
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.