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

143 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
scones8452130(None) 
cones76457421_cones
icones84616381icones
scenes84520351scenes
sconces113811451sconces
scone74621831scone_
scopes104719591scopes
scores84725921scores
sones55444141s_ones
stones65130031stones
acnes75922622ac_nes
agones75719862agones
ancones93116342ancones
atones65225772atones
axones134614512axones
bones76446532_bones
canes75350372_canes
cines75239682_cines
clones84526562clones
codes86247292_codes
cokes115537192_cokes
coles76055062_coles
comes97246992_comes
cone67256962_cone_
coned86040052_coned
coney105932882_coney
coneys115218422_coneys
conges94928172_conges
conies84338592_conies
conks115525702_conks
conns75024232_conns
cons66057692_con_s
contes84432912_contes
conus76726532_conus
copes97747102_copes
cores76361852_cores
coses76949492_coses
cotes76347842_cotes
coves105539172_coves
coxes145430862_coxes
cozes166033242_cozes
crones84729242crones
drones75023432drones
hones88144492_hones
icons76516492icon_s
irones64724012irones
jones125028182_jones
leones64417722leones
nones55639132_nones
ones46146532__ones
oscines9310362oscines
ozones1539392ozones
peones83821042peones
phones114121212phones
pones74547042_pones
sanes55649072s_anes
scales84529312scales
scans74625102scan_s
scants85219722scants
scapes105122262scapes
scares85033002scares
scenas84114702scenas
scends95213002scends
scene77220572scene_
scents85317022scents
scions82612242scion_s
scoffs14347502scoffs
scolds95011232scolds
scolex1538242scolex
sconce104711722sconce
sconced12359172sconced
scoops105414362scoops
scoots85315942scoots
scope94821482scope_
scoped115116652scoped
scops95820192sco_ps
score75526742score_
scored94621132scored
scorer84818262scorer
scorers94115322scorers
scorned10229952scorned
scorner9259762scorner
scorners10228492scorners
scorns85713022scorns
scoter83815482scoter
scoters93313812scoters
scots74025912sco_ts
scours84913592scours
scouse84113632scouse
scouses93313242scouses
scouts84817942scouts
scowed124413832scowed
scowls11549592scowls
scows106617802sco_ws
screes85023972screes
scries85226822scries
scutes85219192scutes
secondes1138132secondes
seconds1038282seconds
seines65029902seines
shines95028912shines
shoes85429662sho_es
shone83725982shone_
shores94830412shores
shotes95321912shotes
shoves124919422shoves
sines55954822s_ines
skenes104616632skenes
sloes54728872slo_es
slopes84820452slopes
smokes124814342smokes
snores64324322snores
socles8418452socles
sokes95031422s_okes
soles55547922s_oles
sondes74922872s_ondes
sone46649982s_one_
songs67725552s_ongs
sons46049552s_on_s
sooner64220462sooner
sooners73916642sooners
soonest7415592soonest
sores55454282s_ores
spines85132032spines
spodes94817432spodes
spokes124417212spokes
sponges10311042sponges
spores84726612spores
stanes64933402stanes
stokes104821792stokes
stoles63927672stoles
stone55431182stone_
stoned75923142stoned
stoner65823202stoner
stoners74817952stoners
stoney96217352stoney
stopes84525892stopes
stores65533662stores
stoves93818922stoves
sycoses1249132sycoses
tones56048662_tones
trones65629282trones
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.376475242.0
2DLD Change Limit825511432.39034540.2
3Display Results1431430.0463108.7
 (SQL Overall)1786911432.81263545.9
 
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.