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

240 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
shortens1128899(None) 
chortens13308791chortens
shorten103511411shorten_
chorten122811302chorten_
sharpens13377812sharpens
shooters112811582shooters
shorans102812412shor_ans
shores94830412shor_e_s
shorted113614402shorte_d
shortened1345662shortened
shortener1245772shortener
shorteners1345082shorteners
shorter103515502shorte_r
shortest11310782shortest
shortias1148092shortias
shorties11414582shorties
shorting122514802shorting
shortness1236732shortness
shorts95321742short__s
shotes95321912sho_te_s
shotten10288462shotten_
shouters113510622shouters
smartens10286662smartens
snorters83410582snorters
softens10347622s_oftens
sorters74221132s_orters
sporters103714062sporters
stoutens8255272stoutens
aborters1038573aborters
assorters965733assorters
boreens9310403_boreens
charters134115583charters
chastens13429183chastens
choreas124414203chor_eas
chores114828023chor_e_s
chorines132917253chorines
chorions13310663chorions
chortlers14305663chortlers
chortles133611323chortles
cortins92421333_cortins
exhorters1944713exhorters
fortes95327183_forte_s
gorhens1137183_gorhens
haptens124511343_haptens
hardens113815023_hardens
harkens144112863_harkens
hastens106214813_hastens
heartens113010153heartens
hoarsens11306023_hoarsens
hoddens12378803_hoddens
hoidens11329083_hoidens
hooters104520473_hooters
hordeins1238323_hordeins
hordes104921633_horde_s
hornets104113553_hornets
horns86125333_hor__ns
horrent10313553_horrent
horses94729343_horse_s
horstes104516113_horste_s
hostels103712313_hostels
hostess103210243_hostess
hotels94515513_ho_tels
hoydens14347403_hoydens
hurters103413643_hurters
martens93714953_martens
moorhens1344853moorhens
moreens939963_moreens
morgens10310463_morgens
phorates13413043phorate_s
photons123814433pho_tons
portend103411193_portend
portends11358963_portends
portent93619643_portent
portents103512823_portents
porters93722703_porters
sarsens7311393s_arsens
scooters103511033scooters
scorers94115323scor_ers
scores84725923scor_e_s
scorners10228493scorners
scorns85713023scor__ns
scoters93313813sco_ters
scouters103411323scouters
screens95212183s_creens
shagreens1342633shagreens
shaitans1136413shaitans
shanteys14395513shanteys
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharns95516983shar__ns
sharpen12389723sharpen_
sharpers133810943sharpers
shatters113313913shatters
shebeens1343333shebeens
sheens95116993sh__eens
sheeters113111863sheeters
sheitans1155603sheitans
shelters113412813shelters
sherbets1335213sherbets
shereefs1433863shereefs
shifters14319863shifters
shippens15316803shippens
shires95225573shir_e_s
shirkers15319583shirkers
shirting123213613shirting
shirtings13276603shirtings
shirtless12266413shirtless
shirts94918343shirt__s
shnorrers1243533shnorrers
shoats94117083shoat__s
shockers17319463shockers
shodden12265763shodden_
shoeless1137803shoeless
shoers94518333sho__ers
shoes85429663sho__e_s
shoetrees1244353shoetrees
shoguns1134423sho_guns
shooter103013993shoote_r
shooting122812863shooting
shootings13266063shootings
shoots94619363shoot__s
shopmen14277203shopmen_
shoppers153010763shoppers
shoppes143411393shoppe_s
shoran94016043shor_an_
shore85432653shor_e__
shored105723653shor_e_d
shoreless1236633shoreless
shoring112820073shor_ing
shorings12269483shorings
shorls94516203shor__ls
shorn85722183shor__n_
short85040533short___
shortage1236313shortage
shortages1336513shortages
shortcut1344453shortcut
shortcuts1442513shortcuts
shortening1445303shortening
shortenings1542683shortenings
shorthand1643753shorthand
shorthands1743493shorthands
shorthead1644473shorthead
shortheads1743813shortheads
shorthorns1643613shorthorns
shortia1048193short_ia
shortie10411343short_ie
shortish1437423shortish
shortlist1246683shortlist
shortly13387573short_ly
shorty124313203short__y
shote85526103sho_te__
shotguns1242313shotguns
shots84730853sho_t__s
shotted113912403shotte_d
shotting123012383shotting
shotts93614703sho_t_ts
shouted113911553shoute_d
shouter103213083shoute_r
shouting122711793shouting
shouts94017723shout__s
shovels13378393sho_vels
shovers134613003sho_vers
shoves124919423sho_ve_s
showers134612683sho_wers
showmen15227173showmen_
shreds105613053sh_r_eds
shrews129313923sh_r_ews
shrieks14377673sh_rieks
shrines104618693sh_rines
shtetels1143233shtetels
shunters113210753shunters
shutes93518223sh_ute_s
shutters113611353shutters
shysters14106463shysters
sirens65318153s_ir_ens
skirters12337243skirters
skorts104211303skort__s
slotters84012403slotters
slovens10316573slo_vens
smarten9348863smarten_
smoothens14194253smoothens
snorers74313803snor_ers
snores64324323snor_e_s
snorkels1234413snorkels
snorted83813493snorte_d
snorter74412663snorte_r
snorting92613373snorting
snorts64116503snort__s
soddens9348413s_oddens
soften9429493s_often_
sorbent92915243s_orbent
sorbents10279133s_orbents
sorbets93012513s_orbets
sorels63921163s_or_els
sores55454283s_or_e_s
sorites73825243s_orite_s
sorners73416873s_orners
sorns55028423s_or__ns
sorrels7310723s_orrels
sorted74523713s_orte_d
sorter64425093s_orte_r
sorties74126403s_orties
sorting83221813s_orting
sorts54536663s_ort__s
souters74422603s_outers
sowens93613153s_o_wens
spores84726613spor_e_s
sporrans1045523sporrans
sported104015433sporte_d
sporter93616553sporte_r
sporting112415463sporting
sports84619183sport__s
spotters104313383spotters
spouters104011163spouters
spurters103311703spurters
starters83714773starters
stollens835293stollens
storers75018683stor_ers
stores65533663stor_e_s
storeys10559653stor_eys
stories7324273storie_s
stotins73213873sto_tins
stouten7307333stouten_
sweetens11255433sweetens
swotters11448483swotters
syrens94911993s_yr_ens
thirteens1243003thirteens
thorites11312393thorite_s
thorns95314103thor__ns
thorons104511913thor_ons
thorpes125010353thorpe_s
torten65314353_torten_
tortes64826053_torte_s
wheatens1454663wheatens
whitens13428733wh_itens
whores125617103whor_e_s
whortles14306743whortles
whorts125111433whort__s
worsens104610263_worsens

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622406.53022383.2
3Display Results2402400.0932580.6
 (SQL Overall)1786912407.04625360.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.