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

101 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
noble7442099(None) 
coble94823171coble
nobble103814311nobble
nobler83713451nobler
nobles83319721nobles
nobly105314401nobly
roble75223021roble
able66340532_able
amble95924632amble
anole55330372ano_le
bible95119412bible
bobble94115142bobble
bogle85821682bogle
bole66448692bo_le
boule74828042boule
cable95329912cable
cobble123615262cobble
cobles104622882cobles
cole66956112co_le
doable93115242doable
dobie84920322dobie
dobla84913642dobla
dole56550002do_le
double94013992double
enable83318482enable
ennoble935632ennoble
fable105824752fable
foible11410382foible
gable85325522gable
gobble113512982gobble
goblet93219482goblet
hobble133913432hobble
hole77553392ho_le
hoyle11314412hoyle
ignoble1043612ignoble
jole117233822jo_le
joule124918202joule
lobe65535362lob_e
lobule82910062lobule
mobile103613532mobile
mobled113213182mobled
mole66251832mo_le
nabe66029492nab_e
nebule848752nebule
nibble103713282nibble
nimble103412932nimble
nob58954422nob__
nobbled123511282nobbled
nobbler113211182nobbler
nobbles114014522nobbles
nobby125513452nobby
noblest93613562noblest
nobs66436902nob_s
noddle83211362noddle
node513036882no_de
nodule7309802nodule
noel45226552noel_
noels56418702noels
noil46133242noil_
noils55024332noils
noily86120992noily
noise55723732noise
nolo46229312no_lo
nombles113212342nombles
nome66038422no_me
nonce75719822nonce
none45743172no_ne
noodle73212542noodle
noose55624062noose
nope65934192no_pe
nose46739362no_se
notable92114902notable
note46239962no_te
novae85913122novae
novel85615992novel
nozzle14236632nozzle
nubble103813712nubble
nubile83212702nubile
obe56638642_ob_e
oboe66822942_oboe
obole75917142_obole
ogle56325052_ogle
ole37155212_o_le
orle45630462_orle
pole65951302po_le
robe65335642rob_e
robles85321692robles
role45851822ro_le
rouble83913312rouble
ruble74521252ruble
sable74732162sable
socle7419572socle
sole46053672so_le
table75429602table
toile54626492toile
tole46052902to_le
unable83819222unable
voile84719722voile
vole75236982vo_le
wobble133212312wobble
yodle94515042yodle

Search took 2 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 Filter178691538000.0931921408.6
2DLD Change Limit538001011.48636204.6
3Display Results1011010.0303366.7
 (SQL Overall)1786911011.609111057.2
 
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.