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

157 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
recharts133766(None) 
rechart12314331rechart_
becharms1745342becharms
charts115823092__charts
echards1337962_echards
recants93217092rec_ants
recasts93413532rec_asts
recharge1476612recharge
recharges1586952recharges
recharted1557562recharted
recharter1466892recharter
recharters1555422recharters
recheats1339192recheats
recoats92616642recoa_ts
restarts8310872restarts
bechalks1944793bechalks
becharm1636843bechar_m
brechams1745773brecha_ms
brechans1547413brecha_ns
carts78946293__c_arts
chants115020393__chants
charas114223613__charas
chards125119733__chards
chares115631803__chares
charks155219703__charks
charms135218843__charms
charrs115219193__charrs
chars105936643__char_s
chart105038283__chart_
chats105730093__cha_ts
cherts115617233__cherts
decants103514443dec_ants
decares102818533dec_ares
deciares11510633deciares
declares11611313declares
dehorts11379773de_horts
departs104310683de_parts
ecarte84313503_ec_arte
ecartes94212563_ec_artes
echard1249223_echar_d
eclats8313033_ecla_ts
enchants1347833enchants
eschars1237183eschar_s
etchants1346023etchants
eucharis1347443eucharis
exhorts1746313_exhorts
harts88441593___harts
hearts96218943he__arts
hectares1338853hectares
lechers123313963lecher_s
merchants1646223merchants
nectars938463nectar_s
orchards1445913orchards
oxcarts1634313oxc_arts
pechans14810503pecha_ns
penchants1646203penchants
pochards1646853pochards
precasts1239453prec_asts
precharge1745163precharge
precharges1845513precharges
rachets124516833rach_ets
ramparts1245583ramparts
reachers133515723reacher_s
reactants1146623reactants
reacts83616603re__acts
readapts1145583readapts
rearms85114653re__arms
rears54739653re__ar_s
rebaits9312573re_baits
rebars84019833re_bar_s
reboards1138773reboards
recalls92613623rec_alls
recanes93222263rec_anes
recant83228683rec_ant_
recaps103615733rec_a_ps
recarpets1344383rec_arpets
recarry1245063rec_arry
recast83422773rec_ast_
receipts1274693receipts
recepts113010263rec_epts
rechange1458183rechange
rechanges1568183rechanges
recharged1656333recharged
recharger1565483recharger
rechargers1644103rechargers
recharting1637213recharting
recheat12415933recheat_
rechecks1944553rechecks
rechews1537293rech_ews
recits83621353rec__its
reclads1049993recla_ds
reclaims1236113reclaims
reclames12310893reclames
reclasps1235053reclasps
recoals94214623recoa_ls
recoat84024273recoa_t_
records105213923rec_ords
recorks134813023rec_orks
recounts1038773recounts
recrate92621663recra_te
recrates102420373recrates
recreants1146623recreants
recruits1036563recruits
rectors93520523rector_s
recurs83315803rec_ur_s
recusants1145103recusants
recuts83817373rec__uts
redacts10510943re_dacts
redbaits1135903redbaits
redcoats1147123redcoa_ts
redears82814453redear_s
redrafts1235603redrafts
redshirts1342903redshirts
redstarts1044243redstarts
redwares1239053redwares
reearns749103re_earns
reenacts1036993reenacts
refracts13137383refracts
regards94112563re_gards
regears83012463regear_s
regrafts1235303regrafts
regrants9310013regrants
rehabs1139023re_ha_bs
rehangs1137563re_hangs
rehears103312773rehear_s
reheats104513523re_heats
rehires105016113re_hires
relearns836303relearns
remarks13329983re_marks
remnants1036843remnants
reparks13249513re_parks
repasts93611933re_pasts
repeats94316053repea_ts
replants102811243replants
reports94916213re_ports
reseats74319583resea_ts
reshapes1338803reshapes
reshaves1438733reshaves
reshoots11228413reshoots
resorts74817193re_sorts
restart7320033restart_
retards85015003re_tards
retears72814923retear_s
retorts76016513re_torts
retracts101111313retracts
reverts104715043re_verts
rewards114813993re_wards
rewarms12439603re_warms
rewears102911043rewear_s
reynards1244303reynards
rochets124213473roch_ets
scarts85321493_sc_arts
secants93413893sec_ants
secpars1138413secpar_s
teacarts10116073teacarts
trochars1377853trochar_s
wechts1446253wech__ts

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.423422437.4
2DLD Change Limit1461621578.04618165.8
3Display Results1571570.0632492.1
 (SQL Overall)1786911578.53220943.6
 
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.