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

111 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
toluole73611(None) 
toluol636901toluol_
toluoles835511toluoles
toluols735821toluols
soluble966102soluble
toluate7159342toluate
toluene736462toluene
toluide835262toluide
toluyl933442toluyl_
toluyls1032832toluyls
tousle64514652to_usle
touzle15429002to_uzle
voluble1244502voluble
bolthole1345463bolthole
boucle103712783bo_ucle
boule74828043bo_u_le
boulle84614613bo_ulle
coalhole1345093coalhole
colone85425003col_one
columel1136273columel
colure8314163colu_re
condole102914953condole
console92715983console
couple104415963co_uple
double94013993do_uble
foliose10378013foliose
foveole13106873foveole
foxhole2045073foxhole
joule124918203jo_u_le
lobule82910063lobu_le
locule83412033locu_le
module93011033modu_le
nodule7309803nodu_le
nonuple946153nonuple
obole75917143_o_bole
oilhole1046263oilhole
oriole6814293_oriole
osmole8128513_osmole
ovule839493_ovu_le
pilule8411123pilu_le
polyol1138713polyol_
polyols1238493polyols
posole8314223po_sole
pothole12312173pothole
pozole1758913po_zole
rouble83913313ro_uble
solubles1065893solubles
solubly1255283solubly
solute64016663solu_te
tadpole1036143tadpole
talcose938133talcose
tallol63612223tallol_
tallols73311363tallols
taphole1239773taphole
telome8311923tel_ome
thole85620843t__hole
toddle85811033to_ddle
toehold1146573toehold
toggle83810873to_ggle
togue64816303togu__e
toile54626493to__ile
toilsome1045203toilsome
tolane64316583tol_ane
tole46052903t___ole
toll45535263tol__l_
tollage82610163tollage
tolled73819033tol__led
toller63819443tol__ler
tolls54728433tol__ls
tolu45529153tolu___
toluates8138903toluates
toluenes836763toluenes
toluic837693tolu_ic
toluid738213tolu_id
toluides935553toluides
toluids835323toluids
tolus55024483tolu__s
tolyl84710093tol_yl_
tolyls9436963tol_yls
tombola1146093tombola
tombolo1146103tombolo
tool46735683to__ol_
tooled74918903to__oled
tooler63818613to__oler
tools55325243to__ols
tootle62613813to_otle
topple104411323to_pple
toque145113093toqu__e
torose64317693to_rose
tortile7313193tortile
torula6610393toru_la
torulae758553torulae
totable92313363totable
touche114916173to_uche
toupee8316133to_upee
touse55430673to_u_se
tousled84710363to_usled
tousles74113933to_usles
touzled17367153to_uzled
touzles16359223to_uzles
towable121910113towable
towrope1245583towrope
trouble957713trouble
tubule839853tubu_le
tule45735873t__u_le
tulle54019933t__ulle
vacuole1245373vacuole
volubly1543553volubly
volume11358273volu_me
volute93912763volu_te
zonule1577483zonu_le

Search took 7 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.1561145455.1
2DLD Change Limit1340271116.70319995.1
3Display Results1111110.0333363.6
 (SQL Overall)1786911116.89225927.3
 
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.