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

136 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
niobates103728(None) 
niobate937701niobate_
niobites1037311niobites
iodates8312902_iodates
neonates8310062neonates
nictates1039592nictates
nidates8311892ni_dates
niobite937952niobite_
nitrates82516222nitrates
notates72817482n_otates
probates12414282probates
violates11311192violates
abates85825033__abates
airdates939723airdates
animates101316423ani_mates
annotates977293annotates
bates75846343___bates
bilobate1247033bilobate_
bilobated1444973bilobated
biogases1136143biogases
biotites10310083biotites
borates94823013_borates
bromates12413143bromates
cholates132414763cholates
ciliates10413453ciliates
citrates102315093citrates
cohobates1646523cohobates
comates114123643_comates
debates103718533_debates
diabases1137223diabases
diabetes1147023diabetes
dictates11311383dictates
dilates83220663di_lates
diorites9313523diorites
dioxanes1645373dioxanes
disrates91118153disrates
donates83217223_donates
etiolates949213etiolates
filiates11412663filiates
fixates1737393fi_xates
folates103218453_folates
globate1057823globate_
globated1265753globated
ideates8313733_ideates
incubates1347603incubates
inflates11512193inflates
ingates82716913_ingates
ingrates9514173ingrates
initiates9411183initiates
inmates92715783_inmates
innovates1245523innovates
inosites8312793inosites
insolates9311273insolates
instates81615833instates
intonates9410243intonates
intubates1147123intubates
invocates1447643invocates
iodate7313503_iodate_
iodated9310023_iodated
iolites73819483_iolites
isobares1046513isobares
isobaths1343833isobaths
isolates8613513isolates
juniorates1743583juniorates
kilobases1543913kilobases
kilobytes1843113kilobytes
librates103412953librates
ligates82318383li_gates
limbate1139213limbate_
liquates1737453liquates
lobate82915243_lobate_
lobated102610943_lobated
locates93218813_locates
migrates111112853migrates
misdates111113633misdates
mismates121114563mismates
misrates101318243misrates
narrates8312763narrates
nates55238333n___ates
negates83215843n_egates
neonate7311333neonate_
nibbles114011693ni_bbles
nictate9310223nictate_
nictated1137793nictated
nidate7313783ni_date_
nidated939863ni_dated
nimbuses1244663nimbuses
niobiums1243373niobiums
niobous936333niob_ous
nites55736343ni___tes
nitrate72017013nitrate_
nitrated92213153nitrated
nitrites82313453nitrites
nizamates2043273nizamates
nobbles114014523n_obbles
nobles83319723n_ob_les
nonages8313843n_onages
nopales93812523n_opales
norites74018803n_orites
notate63217863n_otate_
notated82713663n_otated
notes55034583n_o__tes
noyades1136563n_oyades
numbats1137673numbat_s
nutates73214973n_utates
oblates91913243__oblates
odonates947743odonates
orates64328613__orates
ozonates1745963ozonates
phonates13410643phonates
phorates13413043phorates
picrates122013213picrates
pirates93020333pi_rates
priorates11410763priorates
probate11414483probate_
probated13410863probated
pronates10418373pronates
prorates10418073prorates
rebates95123183_rebates
rotates72819773_rotates
sinuates8310963sinuates
situates8310373situates
solates73523853_solates
sorbates10311103sorbates
stomates10313343stomates
thionates12106663thionates
timbales12227843timbales
titrates82314663titrates
vibrates132210613vibrates
violate10311553violate_
violated1237883violated
violater1137253violater
violaters1245963violaters
virgates1237923virgates
vitiates112311433vitiates
zincates1937743zincates

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 Limit1461621367.07620656.0
3Display Results1361360.0632158.7
 (SQL Overall)1786911367.56223630.1
 
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.