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

307 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
recross98983(None) 
across8312642_across
cross75124502__cross
incross937662incross
necrose939722necrose
necroses10310562necroses
necrosis1048882necrosis
recess8314262rec_ess
rechose121312042rechose
reckons13269652reckons
recons84922992rec_ons
recooks134711232recooks
records105213922records
recorks134813022recorks
recrossed1246512recrossed
recrosses1138372recrosses
recrown12257572recrown
recrowns13246142recrowns
rectors93520512rectors
rectos85718782recto_s
redress82511872redress
regloss8218022regloss
regress82711452regress
regrows11269152regrows
repress92712682repress
repros84216002repro_s
rerose63320842re_rose
retros63820192retro_s
uncross938192uncross
acerose9310893acerose
acerous9513333acerous
ancress978613ancress
beckons15279143beckons
beclogs1237073beclogs
becrowd1555173becrowd
becrowds1683773becrowds
becrust1137983becrust
becrusts1244843becrusts
bicrons113410473bicrons
ceros74726073ce_ro_s
cerous85821203ce_rous
coss66143493__c_oss
crass76328043__crass
cress75022833__cress
crocs95722433__crocs
crops96125233__crops
crosse85216303__crosse
crows105727313__crows
dacrons103211033dacrons
declass1038733declass
decorous1138853decorous
decors94017773dec_ors
decos85522123dec_o_s
decoys123911283dec_oys
decrees102513123decrees
decries103319803decries
decrown13206053decrown
decrowns14265063decrowns
defrost1139553defrost
defrosts1244833defrosts
depress10239863depress
dross65418093__dross
echoes114715523_echoes
echos105216463_echo_s
ecrus75113863_ecr_us
egress73310433_egress
emboss1087383_emboss
engross837123engross
enrols61213383_enrols
erectors103514253erectors
eros45238453_e_ro_s
erose55727273_e_rose
eroses65327053_e_roses
errors63311313_errors
escrows1235803escrows
euros54920243_euro_s
ferrous1049793ferrous
geckoes14325793geckoes
geckos13457433gecko_s
genros74211333genro_s
gross65421693__gross
hectors123513263hectors
heiress1036813heiress
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
kaross101910013_kaross
lacrosse1044113lacrosse
lectors93415763lectors
leprose938543leprose
leprosy1244223leprosy
leprous938843leprous
macrons113514893macrons
macros104017013macro_s
metros84217803metro_s
microns113814783microns
micros104115363micro_s
necropsy1542953necropsy
necrosed1137213necrosed
nerols6914883ne_rols
neurons7410443neurons
neuroses8310153neuroses
neurosis848843neurosis
outcross1036813outcross
pedros9312183pedro_s
peeress939503peeress
percuss1137163percuss
perrons93115483perrons
petrols92913083petrols
petrous92714423petrous
precess11310863prec_ess
prechose15129773prechose
precious12310593precious
precooks1656763precooks
precools1237703precools
precrash1544823precrash
precrisis1346453precrisis
prepress12137973prepress
pross76529403__pross
racons84319343rac_ons
racoons93912433racoons
ramrods1036583ramrods
reactors103212283reactors
rearers74323563rearers
rearmost1047263rearmost
rearms85114653rear_ms
rearouse839363rearouse
rearouses9310203rearouses
rears54739653rear__s
reasons72514943reasons
reavows1335273reavows
rebooks134010513rebooks
reboots93512093reboots
rebops10311433re_bops
rebores95319163rebores
recalls92613613recalls
recanes93222263recanes
recants93217093recants
recaps103615733rec_aps
recast83422773rec_ast
recasts93413533recasts
recces10614913rec_ces
recedes102816063recedes
recepts113010263recepts
recesses10312323recesses
rechews1537293rechews
rechoose13137343rechoose
rechooses14107613rechooses
rechosen13127033rechosen
recipes113314463recipes
recites93524583recites
recits83621353rec_its
reckless14257973reckless
reckon123010543recko_n
recks115625133rec__ks
reclads1049993reclads
reclasp1136643reclasp
reclasps1235053reclasps
recluse95210773recluse
recluses105111733recluses
recoal84117973rec_oal
recoals94214623recoals
recoat84024273rec_oat
recoats92616643recoats
recock145112723rec_ock
recocks154711463recocks
recode93618713rec_ode
recodes102918633recodes
recoil84016723rec_oil
recoils93814873recoils
recoin84320293rec_oin
recoins94019243recoins
recolors1078813recolors
recomb1238873rec_omb
recombs1336753recombs
recon75624243rec_o_n
recook125513923rec_ook
recopy1339043rec_opy
record96117423rec_ord
recork126315483rec_ork
recoup10810373rec_oup
recoups1188843recoups
recrate92621643recrate
recrates102420353recrates
recrossing1386973recrossing
recruit939773recruit
recruits1036563recruits
recs65734183rec___s
recto74520803recto__
rector84019743recto_r
rectory123512723rectory
rectums11338523rectums
rectus83314633rec_tus
recurs83315803rec_urs
recurves1337403recurves
recuse85519163rec_use
recuses94619463recuses
recuts83817373rec_uts
redness82012443redness
redoes74623753re_does
redons75222183re_dons
redos65126763re_do_s
redraws11218473redraws
redries83721713redries
redroot8312903redroot
redroots937753redroots
redrove11249423redrove
redtops1037373redtops
reechoes1338413reechoes
reflows13258983reflows
reforms1239813reforms
refresh1335453refresh
refries104419733refries
refront10313263refront
refronts1137773refronts
refroze1956223refroze
regions83613473regions
reglows11288843reglows
regrets83212923regrets
regroom1077293regroom
regrooms1196013regrooms
regroup1095173regroup
regroups11104383regroups
regrow10309883regro_w
regrown11237363regrown
reknots1136783reknots
relooks114010723relooks
remiss84216353re_miss
remoras9314073remoras
remorse9311713remorse
remorses10311993remorses
renvois1036503renvois
repass84114703re_pass
replots93412633replots
replows12329703replows
reports94916213reports
repos74725793re_po_s
repose84121413re_pose
reposes94021263re_poses
repots85621003re_pots
reprise92715043reprise
reprises102615463reprises
repro75315913repro__
reprobe112310133reprobe
reprobes121910293reprobes
reprocess1345933reprocess
reproof1238783reproof
reproofs1346063reproofs
reprove122911073reprove
reproves132011473reproves
rerigs74014793re_rigs
rerise64325633re_rise
rerises73525883re_rises
reroll6412683re_roll
rerolls739943re_rolls
reroof9315003re_roof
reroofs1037943reroofs
reruns66413743re_runs
rescores105415693rescores
reshoes102316033reshoes
reshows132510453reshows
resods74116303re_sods
resorbs95010523resorbs
resorts74817193resorts
resows93915353re_sows
respots92912763respots
restress82511773restress
retools73411023retools
retorts76016513retorts
retries74129073retries
retrims93612373retrims
retro55020953retro__
retrorse837623retrorse
retrousse944613retrousse
reversos11266713reversos
rewords115413973rewords
reworks145113593reworks
rewraps12136563rewraps
rewrote1039113rewrote
rezeroes1737143rezeroes
rezeros1647453rezero_s
ricracs1136363ricracs
rockrose1444953rockrose
rockroses1545563rockroses
ryegrass1242793ryegrass
scrods94111603_scrods
seccos1039923secco_s
secrets9311773secrets
sectors93116433sectors
seeress7311573seeress
serosa6313023se_rosa
serosas7312663se_rosas
serous65023563se_rous
serows96016393se_rows
sucrose939303sucrose
sucroses1039933sucroses
terrors73112203terrors
testcross1142543testcross
topcross1253383topcross
vectors123212593vectors
velcros1244033velcro_s
versos93812803ve_rsos
xeroses143612823xe_roses
xerosis14249663xe_rosis
zebrass1834113zebrass
zeroes154314343ze_roes
zeros144918103ze_ro_s

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.1401276364.3
2DLD Change Limit1340273077.45317983.0
3Display Results3073070.1262436.5
 (SQL Overall)1786913077.71923149.5
 
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.