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 “crones” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

215 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
crones8472924(None) 
clones84526561clones
cones76457421c_ones
cranes84330751cranes
crone75231331crone_
cronies9622501cronies
crores86121161crores
crozes174417661crozes
drones75023431drones
irones64724011irones
trones65629281trones
agones75719862agones
arenes64928392arenes
atones65225772atones
axones134614512axones
bones76446532_bones
brines85028852brines
bromes104719762bromes
broncs101611152broncs
bronzes183510402bronzes
broses86524402broses
cajones163311332cajones
canes75350372c_anes
canoes84725882canoes
chines115029172chines
chokes154917382chokes
chores114828022chores
choses115825132choses
chromes142914932chromes
cines75239682c_ines
cions75222852cion_s
clines84926042clines
clone75728162clone_
cloned94518802cloned
cloner84418092cloner
cloners94514822cloners
clonks125013472clonks
clons75228132clon_s
clonus85212412clonus
closes85425592closes
cloves114918822cloves
clozes174915562clozes
codes86247292c_odes
cojones163512102cojones
cokes115537192c_okes
coles76055062c_oles
colones96124432colones
comes97246992c_omes
cone67256962c_one_
coned86040052c_oned
coney105932882c_oney
coneys115218422c_oneys
conges94928172c_onges
conies84338592c_onies
conks115525702c_onks
conns75024232c_onns
cons66057692c_on_s
contes84432912c_ontes
conus76726532c_onus
cooees85621892cooees
coons76737282coon_s
copes97747102c_opes
cores76361852c_ores
cornea84018922cornea
corneas94717002corneas
corned95224522corned
cornel84020052cornel
cornels94716662cornels
corner84625622corner
corners94723312corners
cornet84436732cornet
cornets94820572cornets
corns76034762corn_s
cornus84816562cornus
coronas93916912coronas
coronel94515222coronel
coronels104012142coronels
coroner94218202coroner
coroners104016222coroners
coronet94227172coronet
coronets103814362coronets
corses84433462corses
corves115122522corves
coses76949492c_oses
cotes76347842c_otes
coves105539172c_oves
coxes145430862c_oxes
cozes166033242c_ozes
crakes124921812crakes
crane75331602crane_
craned96121652craned
cranks125015312cranks
crapes104727692crapes
crases85532312crases
crates85736062crates
craves115825392craves
crazes174720132crazes
cremes104517992cremes
crenel84213062crenel
crenels93711012crenels
creoles9913322creoles
crepes105419342crepes
cries75438402cr_ies
crimes105521582crimes
cringes103215502cringes
cripes105120872cripes
crises84529432crises
croaks125812982croaks
crocks145118422crocks
crocs95722432cro_cs
crocus104813172crocus
crofts114910592crofts
cronish12310862cronish
crony105918672cron_y
crooks124914412crooks
crooned103813342crooned
crooner93714042crooner
crooners103911392crooners
croons85418422croons
crops96125232cro_ps
crore74922862crore_
cross75124502cro_ss
crosse85216302crosse
crosses94220792crosses
croupes114613102croupes
croups104312552croups
crouse84619362crouse
croutes94815652croutes
crowds124910762crowds
crowed124717292crowed
crower114117552crower
crowers124614892crowers
crowned133912422crowned
crowner124012592crowner
crowners133710742crowners
crownet123714112crownet
crownets13407672crownets
crowns115615112crowns
crows105727312cro_ws
croze164719452croze_
crozer175112842crozer
crozers184111082crozers
cruces105117542cruces
crudes96218622crudes
cruses88127712cruses
cruxes154911562cruxes
drone65324982drone_
droned84616862droned
droner74717672droner
droners84114382droners
droves105116672droves
ernes55224812er_nes
erodes74819882erodes
eroses65327052eroses
froes86126692fro_es
fronds106412342fronds
frons86124042fron_s
frontes104214162frontes
fronts94415792fronts
gropes95220402gropes
groves104318102groves
groynes1137822groynes
hones88144492_hones
icones84616382icones
irone55126362irone_
ironed74916012ironed
ironer64216452ironer
ironers74813552ironers
ironies7517422ironies
irons55324132iron_s
jones125028182_jones
krone94018732krone_
kronen10348912kronen
kroner104612572kroner
leones64417722leones
mucrones1237602mucrones
nones55639132_nones
ones46146532__ones
orgones81010792orgones
ozones1539392ozones
peones83821042peones
phones114121212phones
pones74547042_pones
probes104119452probes
proles84627202proles
prone75332622prone_
prongs94314482prongs
proses84733472proses
proves114322252proves
prunes83419062prunes
pyrones123113302pyrones
robes75133302_robes
rodes614039082_rodes
roes45954132_ro_es
roles56747982_roles
ropes75940062_ropes
roses56445772_roses
rotes56143902_rotes
roues56039352_roues
roves84834482_roves
runes55530222_runes
scones84521302scones
sones55444142_sones
stones65130032stones
thrones105715842thrones
tones56048662_tones
trines64132562trines
trokes104019262trokes
tronas63816902tronas
trone55131862trone_
tropes84824352tropes
troves94719112troves
urines64724122urines
wrongs10338932wrongs
zones145528042_zones

Search took 3 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 Filter178691825510.1101624463.6
2DLD Change Limit825512152.62631436.0
3Display Results2152150.0633412.7
 (SQL Overall)1786912152.79963841.0
 
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.