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

140 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
nostocs94755(None) 
nostoc868191nostoc_
bostons9312902bostons
gnostics1146322gnostics
nestors73614972nestors
nonstops10116872nonstops
postdocs1345272postdocs
postops11311712postops
agnostics1244463agnostics
bestows1248863bestows
bosoms104913053bos_oms
bosons85016653bos_ons
boston8513043bosto_n
bottoms1136993bottoms
boutons9310783boutons
bustics11810883bustics
castors94919443castors
cestos84718093cesto_s
contos84923233conto_s
cosecs105015213cos_ecs
cosmos10311753cosmo_s
costars94218013costars
costers94128333costers
costs77231143cost__s
cottons9312193cottons
customs11348263customs
custos84014313custo_s
doctors1039993doctors
estops84011223_estops
foetors1039763foetors
fosters104220103fosters
fustics1279593fustics
gnostic1038433gnostic_
gustoes879873gustoes
hostas94515823host_as
hostels103712313hostels
hostess103210243hostess
hosts85526703host__s
inositols943563inositols
jostles143411143jostles
kotos95717693ko_to_s
kotows13446513ko_tows
kowtows1742763kowtows
lotos54724633lo_to_s
lottos64613103lotto_s
mastics112614783mastics
mosaics1138073mosaics
mosts76028543most__s
motors84616603mo_tors
mottoes93412193mottoes
mottos84615243motto_s
moutons9410313moutons
mystics14279103mystics
nasions73112383nasions
nastic82915973nastic_
nasties73520493nasties
nektons1136393nektons
nesters74422793nesters
nestles73015463nestles
nestor63713423nesto_r
nests55728003nest__s
netops839213n_etops
neustons836833neustons
newtons1036813newtons
nitons64614903n_itons
nocuous946583nocuous
nodous7711333no_dous
noetic8514043noetic_
nolos54423353no_lo_s
nomos75919743no_mo_s
noncoms1139193noncoms
nonstick1447583nonstick
nonstop9106913nonsto_p
nonstory1148093nonstory
nooks95420393no__oks
noons54125283no__ons
norths96812323nort_hs
noses55435643nos__es
noshers103614333noshers
noshes96618233nos_hes
nosings8349593nosings
nostril749293nostril
nostrils848173nostrils
nostrum946953nostrum
nostrums1045683nostrums
notch105613323no_t_ch
noters64021003no_ters
notes55034583no_t_es
notice8313443no_tice
notices9312283no_tices
notions74014483notions
nowts86915863nowt__s
noxious1446563noxious
optics102810183_optics
osmics1036463_osmics
osmols8137313_osmols
osmous8138183_osmous
ostomy1137833_ostomy
ostoses71213553_ostoses
ostosis71310123_ostosis
ottos54714323_otto_s
pastors94119003pastors
pestos84719083pesto_s
pistols93213983pistols
pistons93016373pistons
pistous92714383pistous
poetics11312073poetics
pontons93315553pontons
postals93716373postals
postboys1585273postboys
postdoc1245263postdoc_
posters93928013posters
posties93128813posties
postins93721203postins
postop10511943posto_p
posts75228783post__s
pottos84615873potto_s
restock1338673restock
restocks1437503restocks
roscoes9310923roscoes
rosters73727543rosters
rotors64917953ro_tors
rotos56027883ro_to_s
rustics9810733rustics
sotols63714463so_tols
stoas55126023__stoas
stobs75718233__stobs
stock114417563__stock
stocks124715633__stocks
stoics8311113__stoics
stops74827283__stops
stoss54316343__stoss
stots54828543__stots
stows86622703__stows
testons7313553testons
tictocs1145903tictocs
unstops936993unstops
wontons103310533wontons
xystos16356913xysto_s
zosters163015413zosters

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.1431249587.4
2DLD Change Limit1340271407.68617437.8
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.87522690.9
 
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.