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

105 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
toluenes83676(None) 
toluene736461toluene_
polyenes13510062polyenes
tolanes74216312tol_anes
toluates8138902toluates
toluides935552toluides
toluoles835512toluoles
abluents1045463abluents
alkenes114212753_alkenes
apolunes1045293apolu_nes
blueness1038213_blueness
boletes9316063bol_etes
boluses94113833bolu_ses
bournes93615023bo_urnes
cohunes1249713cohu_nes
coleuses1039713coleuses
colleens1036843colleens
colleges112410513colleges
colognes11310603colognes
colones96124433col_ones
columnea1243673columnea
columneas1343013columneas
columned1334923columned
columns1136473column_s
colures9315143colu_res
convenes132916913convenes
coulees9315503coule_es
diluents946053diluents
dolmens10388693dolmen_s
eluents738703_eluents
goldener1045403goldener
goldenest1147873goldenest
goldeyes1344483goldeyes
lenes54738523__l_enes
lunes55337773__lu_nes
oleines7313393_oleines
pollees93215333polle_es
pollened1157773pollened
pollens93713303pollen_s
polyene1259363polyene_
polygenes1557503polygenes
rouens64814443ro_uen_s
soleness8814263sol_eness
soleuses838073soleuses
solfeges1244083solfeges
solubles1065893solubles
solutes73515263solu_tes
solvents1136763solvents
stilbenes1143933stilbenes
stollens835293stollen_s
talents7312013tal_ents
taluses7311213talu_ses
teleses7313123tel_eses
telexes1438343tel_exes
terpenes102111563terpenes
terrenes82212603terrenes
toffees13327083toffe_es
togues76014243togu__es
tokened1236393to_kened
tokens104711563to_ken_s
tolane64316583tol_ane_
tolans64319273tol_an_s
toledos8388863tol_edos
toles55147133tol___es
tolidines1046883tolidines
tollages92410193tollages
tollers73217463tolle_rs
toluate7159343toluate_
toluide835263toluide_
toluidines1143453toluidines
toluids835323tolu_ids
toluole736113toluole_
toluols735823tolu_ols
tolus55024483tolu___s
toluyls1032833tolu_yls
tonemes9311683to_nemes
tones56048663to___nes
tonnes65320853to__nnes
tontines82114733tontines
tonuses73612193tonu_ses
topees85519703to_pe_es
toplines102412563toplines
toques154612353toqu__es
toquets16367863toque_ts
torments10310453torments
torqueses1842833torqueses
torrents838143torrents
touches125118343to_uches
toupees938513to_upees
tourney1036273to_urney
tourneys1134013to_urneys
touses64229673to_u_ses
tousles74113933to_usles
touzles16359223to_uzles
towhees13277793towhe_es
towlines112610343towlines
townees10269783towne_es
toxines142912263to_xines
trienes74118413t_rienes
triunes74311383triu_nes
trueness838693t_rueness
tunes55332193t__u_nes
volumes12298233volu_mes
volutes102710983volu_tes
xylenes1745093xyl_enes

Search took 9 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.1561145455.1
2DLD Change Limit1461621058.04618165.8
3Display Results1051050.0462282.6
 (SQL Overall)1786911058.24821664.8
 
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.