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

170 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
toluyl93344(None) 
toluol636901toluol
toluyls1032831toluyls
tolyl84710091tol_yl
toll45535262tol__l
tolu45529152tolu__
toluic837692toluic
toluid738212toluid
toluole736112toluole
toluols735822toluols
tolus55024482tolu_s
tolyls9436962tol_yls
alkyl12518043_alkyl
allyl85310543_allyl
atoll57913923atol__l
boldly12399423boldly
boll65634753bol__l
bolus79125543bolu_s
colby124415063colby_
colbys13407153colbys
coldly12459953coldly
colly104926773colly_
colugo935863colugo
columel1136273columel
column1038103column
colure8314163colure
coly96940533col_y_
doll56632493dol__l
dolly96125203dolly_
fluyt114614203_fluyt
foley115222303foley_
foleys123810463foleys
folky159214713folky_
folly115022603folly_
formyl14276443formyl
foul77027583fo_u_l
foully1239013foully
golly95121103golly_
holey115626903holey_
holily123612953holily
holly114824433holly_
holy106333433hol_y_
jolly154517513jolly_
jolty155713033jolty_
joual12311653jo_ual
loll46128383lol__l
lolly85120663lolly_
lull44225763__lull
mogul8310213mogu_l
molal75120343mol_al
moldy115014653moldy_
moll66735703mol__l
molly105222493molly_
moly96031913mol_y_
nonyl849773no_nyl
octyl10136063_octyl
odyl84111463_o_dyl
oldy85316843_oldy_
poleyn1157323poleyn
poll66332133pol__l
poly96235153pol_y_
polyol1138713polyol
polyp125611533pol_yp
polys105718763pol_ys
roll46331653rol__l
solely93714213solely
solgel737963solgel
soluble966103soluble
solubly1255283solubly
solum74717613solu_m
solums85211333solums
solus54726983solu_s
solute64016663solute
soul46435713so_u_l
talky126215683talky_
tall47240213tal__l
tallol63612223tallol
tally84526863tally_
taluk94812873talu_k
taluka10426773taluka
taluks10418283taluks
talus55423263talu_s
telial65815363telial
tell44934703tel__l
telly84920823telly_
tellys9348843tellys
tetryl935693tetryl
thurl84912683t_hurl
thuya1135583t_huya
till45941203til__l
toady96814343toady_
toby96322293to_by_
today96416953today_
todays10458103todays
toddy106812423toddy_
tody86327213to_dy_
toffy145310283toffy_
tofu76921333tofu__
tofus86415423tofu_s
togue64816303togu_e
togues76014243togues
toil46536283to__il
toilful1044813toilful
tokay125513053tokay_
tokays13397773tokays
tola45236333tol__a
tolan55124013tol_an
tolane64316583tolane
tolans64319273tolans
tolar55524113tol_ar
tolars64817943tolars
tolas54532773tol_as
told56132203tol__d
tole46052903tol__e
toled65934923tol_ed
toledo7419993toledo
toles55147133tol_es
toling73926123toling
tolled73819033tolled
toller63819443toller
tolls54728433tol_ls
toluate7159343toluate
toluene736463toluene
toluide835263toluide
toluids835323toluids
toluoles835513toluoles
tombal102311023tombal
tommy124712233tommy_
tonal53724303to_nal
toney86027413toney_
tonsil6311873tonsil
tonus56324303tonu_s
tony75635153to_ny_
tool46735683to__ol
topful1136543topful
topfull1244153topfull
toque145113093toqu_e
toques154612353toques
toquet154414683toquet
torula6610393torula
torus54329763toru_s
tory75840543to_ry_
total55321823to_tal
touch106519393to_uch
tough97321983to_ugh
tour45530383to_u_r
tours55325893to_urs
touse55430673to_use
tousle64514653to_usle
tout46753823to_u_t
touts54830393to_uts
touzle15429003to_uzle
towel84920523to_wel
towny116114493towny_
towy105325473to_wy_
toy69655193to__y_
toyo76925453to__yo
toys78036343to__ys
troll54416533trol__l
trolly94012363trolly_
trotyl9236673trotyl
trull54012673t_rull
truly84111553truly_
voluble1244503voluble
volubly1543553volubly
volume11358273volume
volute93912763volute
woful1158173wofu_l
xylyl1842563xyl_yl
yolky15529523yolky_

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161705.87319192.2
3Display Results1701700.0503400.0
 (SQL Overall)1786911706.31328305.2
 
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.