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

203 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
rechart1231432(None) 
recharts1337661recharts
becharm1636842becharm
chart105038282__chart
echard1249222_echard
recant83228682rec_ant
recast83422772rec_ast
recharge1476612recharge
recharted1557562recharted
recharter1466892recharter
recheat12415932recheat
recoat84024272recoa_t
restart7320032restart
bechalk1845803bechalk
becharms1745343becharms
brecham1646833brecha_m
brechams1745773brechams
brechan1437223brecha_n
brechans1547413brechans
cart66570343__c_art
chant105932693__chant
chapt125827643__chapt
char95132153__char_
chard116124743__chard
chare105231983__chare
chark144222713__chark
charm126124663__charm
charr104821783__charr
chars105936633__chars
charts115823093__charts
chary135023133__chary
chat95546133__cha_t
chert105232103__chert
decant93524223dec_ant
decare93919153dec_are
deciare10710663deciare
declare10411223declare
dehort104618103de_hort
depart94720563de_part
ecarte84313503_ec_arte
echards1337963_echards
echt95722903_ech__t
eclat7523603_ecla_t
enchant12313103enchant
eschar1136523eschar_
eschars1237173eschars
etchant1249813etchant
exhort16410803_exhort
hart76865773___hart
heart85440743he__art
hectare1238463hectare
lecher113415853lecher_
lechers123313963lechers
lechery15257643lechery
merchant1548793merchant
nectar838853nectar_
nectars938463nectars
nectary1246223nectary
orchard1346933orchard
oxcart1539523oxc_art
peart76440753pe__art
peccant13311733peccant
peccary1636283peccary
pechan13511543pecha_n
pechans14810503pechans
penchant1549563penchant
pochard1537363pochard
precast11314853prec_ast
precharge1745163precharge
rachet115028973rach_et
rampart11311993rampart
reacher123718293reacher_
reachers133515723reachers
react74634333re__act
reactant10311433reactant
readapt1039743readapt
rear45644553re__ar_
rearm75923563re__arm
rears54739653re__ars
rebait8320403re_bait
rebar75420193re_bar_
rebars84019823re_bars
reboant9315093reboant
reboard10310763reboard
recall83815723rec_all
recane83022873rec_ane
recants93217093rec_ants
recap95718023rec_a_p
recaps103615733rec_aps
recarpet12310603rec_arpet
recarry1245063recarry
recasts93413533rec_asts
receipt1159253receipt
recent83630853rec_ent
recept103319073rec_ept
rechange1458183rechange
recharged1656333recharged
recharger1565483recharger
recharges1586953recharges
recharters1555423recharters
recharting1637213recharting
recheats1339193recheats
recheck1835613recheck
rechew14310213rech_ew
rechews1537293rechews
rechose121312043rechose
recit75235103rec__it
reclad9311873recla_d
reclads1049993reclads
reclaim1137753reclaim
reclame11411063reclame
reclasp1136643reclasp
recoal84117973recoa_l
recoals94214623recoals
recoats92616643recoats
record96117423rec_ord
recork126315483rec_ork
recount9315173recount
recrate92621643recrate
recreant10311283recreant
recruit939773recruit
recta74220263recta__
rectal84418133recta_l
rector84019743rector_
rectors93520513rectors
rectory123512723rectory
recur74116843rec_ur_
recurs83315803rec_urs
recusant1049463recusant
recut74729243rec__ut
redact9419043re_dact
redbait1039803redbait
redcoat10410883redcoa_t
redear73515173redear_
redears82814453redears
redraft11310573redraft
redshirt1245853redshirt
redstart949193redstart
redware1139353redware
reearn6612143re_earn
reenact9413003reenact
refract121311603refract
regard85215773re_gard
regear73512743regear_
regears83012463regears
regnant8312843regnant
regraft11310153regraft
regrant8317323regrant
rehab10312443re_ha_b
rehabs1139023re_habs
rehang1039823re_hang
rehash1237433re_hash
rehear93713223rehear_
reheard11309023reheard
rehears103312773rehears
reheat94423943re_heat
rehire95415863re_hire
relearn747973relearn
relearnt849213relearnt
reliant7319243reliant
remark123512373re_mark
remnant9312633remnant
repark123511713re_park
repast83520633re_past
repeat85127213repea_t
replant93318533replant
report85326013re_port
reptant92817073reptant
resat55139683re_sa_t
reseat64131493resea_t
reshape1249043reshape
reshave1338603reshave
reshoot102513893reshoot
reshot93519633resh_ot
resort65728613re_sort
restarts8310873restarts
retard75018933re_tard
retear63115483retear_
retears72814923retears
retiary1038333retiary
retort66831143re_tort
retract91318113retract
revert93529113re_vert
reward106017633re_ward
rewarm115913483re_warm
rewear93011993rewear_
rewears102911033rewears
rewrapt12138113rewrapt
reynard1135123reynard
richer114015043richer_
richest122813683richest
rochet115423003roch_et
scart76139773_sc_art
secant84023293sec_ant
secpar1037923secpar_
secpars1138413secpars
sectary1238273sectary
teacart91113193teacart
trenchant1446323trenchant
trochar1257063trochar_
trochars1377843trochars
unchary1537263unchary
wecht13415443wech__t

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.1731032896.0
2DLD Change Limit1340272036.79619721.5
3Display Results2032030.0633222.2
 (SQL Overall)1786912037.03225411.1
 
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.