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

162 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
recleans103751(None) 
precleans1344891precleans
reclean938521reclean_
cleans85817052__cleans
preclean1245892preclean_
preclears1344372preclears
recheats1339192recheats
reclads1049992recl_ads
recleaned1236582recleaned
recreant10311282recreant
recreants1146622recreants
relearns836302re_learns
reloans7313132re_loans
replans92814942repl_ans
repleads11357202repleads
becloaks1644933becloaks
beclowns1544683beclowns
befleas1236973beflea_s
beleaps1138053be_leaps
bemeans1148733be_means
brechans1547413brec_hans
ceruleans1192923ceruleans
clans75031013__cl_ans
clean75420413__clean_
cleanse9358723__cleanse
clears84116563__clears
cleats84919313__cleats
decerns10119053dec_erns
declass1038733decl_ass
declaws1336253decl_aws
defleas1147223deflea_s
deleads9379703de_leads
demeans1039713de_means
eclats8313033_ecl_ats
elans55527753_e_l_ans
gleans75014743__gleans
leans55536253___leans
lecterns1035943lecterns
melenas999203me_lenas
nucleins1046083nucleins
nucleons1065483nucleons
oceans81211003_oc_eans
overcleans15134883overcleans
pecans101515833pec__ans
pechans14810503pec_hans
pectens11189203pecte_ns
precleaned1543793precleaned
preclear1245423preclea_r
preplans1249613prepl_ans
raglans82410133ragl_ans
reales64934123reale__s
realgars934533realgars
realigns936253realigns
reblend1036653reble_nd
reblends1135293reblends
reblent9614253reble_nt
recane83022873rec__ane
recanes93222263rec__anes
recant83228683rec__ant
recants93217093rec__ants
recaps103615733rec__aps
recces10614913recce__s
recedes102816063rec_edes
recent83630853rec_e_nt
recepts113010263rec_epts
recess8314263rec_e_ss
recheat12415933rechea_t
rechecks1944553rechecks
rechews1537293reche_ws
recitals1039763recitals
reckless14257973reckle_ss
reckons13269653rec_kons
reclad9311873recl_a_d
reclaim1137753recl_aim
reclaims1236113reclaims
reclame11411063recl_ame
reclames12310893reclames
reclasp1136643recl_asp
reclasps1235053reclasps
recleaning1336753recleaning
recline94020493recl_ine
reclines103718543reclines
recluses105111733recluses
recoals94214623rec_oals
recoats92616643rec_oats
recoins94019243rec_oins
recons84922993rec__ons
recreance1346983recreance
recreances1446503recreances
recreancy1643783recreancy
recreate10313603recreate
recreates11313343recreates
recrowns13246143recrowns
recusals1056393recusals
recusant1049463recusant
recusants1145103recusants
redans75421023re__dans
reddens9259783redde_ns
redears82814453re_dears
redheads1336173redheads
redlegs936823redle_gs
redreams1195953redreams
reearns749103re__earns
reelects103110883reelects
reelers73520273reele_rs
reflags1156953refl_ags
reflects13288873reflects
reflets103513153refle_ts
reflexes1865923reflexes
refloats1156913refloats
regears83012463re_gears
reglets83512983regle_ts
regreens9257453regreens
rehears103312773re_hears
reheats104513523re_heats
reland75920433re_l_and
relands85214883re_l_ands
relays94316753re_l_ays
relearn747973re_learn
relearnt849213re_learnt
release7312763re_lease
releases8313343re_leases
relend76116453re_le_nd
relends84013253re_lends
relent64431853re_le_nt
relents74018503re_lents
relets64025673re_le_ts
relevant1149243re_levant
releves103914973re_leves
reliant7319243re_liant
relleno796463relle_no
rellenos8125493rellenos
reloads8911313re_loads
reloan6415693re_loan_
remans84823003re__mans
reopens939373reope_ns
repeals94014523re_peals
repeats94316053re_peats
replan83215823repl_an_
replant93318533repl_ant
replants102811243repl_ants
replays12399763repl_ays
replead10399003replea_d
repletes102812463repletes
replevins1465203replevins
rereads81512293re_reads
rescreens1144863rescreens
reseals73917663re_seals
reseats74319583re_seats
reseaus74012153re_seaus
respeaks1434953respeaks
reteams9339563re_teams
retears72814923re_tears
retreads937823retreads
retreats8311403retreats
reveals103812723re_veals
rewears102911033re_wears
richens12349733riche_ns
rouleaus844973rouleaus
secerns987733sec_erns
telerans859473te_lerans
unclean946973unclean_

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 Filter1786911461620.1701051123.5
2DLD Change Limit1461621628.62616944.4
3Display Results1621620.0632571.4
 (SQL Overall)1786911628.85920170.6
 
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.