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

164 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
trotyls1023603(None) 
protyls12298461protyls
trotyl9236671trotyl_
propyls14308192propyls
protyl11308212protyl_
protyle12229452protyle
protyles13249832protyles
rotls55620162_rot_ls
tolyls9436962t_olyls
totals63115162t_otals
trolls64613942tro_lls
troths95414152trot_hs
trots56629942trot__s
trowels10358362trowels
troys86418612tro_y_s
acetyls12285353acetyls
artels66216233ar_tels
aryls87015813ar__yls
botels84815803_botels
broils84114173bro_ils
bromals1139743bromals
brothels13277073brothels
broths115013923brot_hs
butyls1176753_butyls
chromyls18244733chromyls
cresyls1234753cresyls
crotons93714373crotons
dactyls1333913dactyls
dicotyls1444183dicotyls
drolls75312393dro_lls
drools74412813dro_ols
erotics91914153erotics
ethoxyls2142213ethoxyls
formyls15235703formyls
frontals1146273frontals
froths125411443frot_hs
grots65025853grot__s
grottos8337333grottos
grovels11427813grovels
growls104711113gro_wls
hotels94515513_hotels
mortals93914003mortals
motels83616893_motels
nitrosyls1242433nitrosyls
nonyls957853_nonyls
octyls11135323_octyls
odyls9428653__odyls
pentyls1236523pentyls
portals94015563portals
propels113412843propels
propyl13358183propyl_
propyla14296633propyla
prostyle13187273prostyle
prostyles14157113prostyles
proteas92015123proteas
proteus92511593proteus
protons93118003protons
prowls115511083pro_wls
ratals64219583_ratals
ratels64518213_ratels
roils54826793_ro_ils
rolls55326233_ro_lls
rotas54827723_rot_as
rotes56143903_rot_es
rotis56327063_rot_is
rotl45029683_rot_l_
rotors64917953_rotors
rotos56027883_rot_os
rots46454093_rot__s
rottes64524833_rottes
rowels94515453_rowels
royals93711263_royals
sotols63714473_sotols
strobils1046563strobils
strolls739183stro_lls
strongyls1343153strongyls
stroys95914603stro_y_s
tarots66422993tarot__s
tetryls1034643tetryls
thionyls1442943thionyls
throttle1164083throttle
throttles1254353throttles
toils54527493t_o_ils
tolls54728433t_o_lls
toluyls1032833toluyls
tolyl84710093t_olyl_
tools55325243t_o_ols
tooters73818773tooters
tooths96013803toot_hs
tootle62613813toot_le
tootles72915603tootles
toots55331873toot__s
tootses72910773tootses
tortas64918253tort_as
tortes64826053tort_es
tortile7313193tortile
torts56138123tort__s
total55321823t_otal_
totems86810763t_otems
toters65026363t_oters
totes55139683t_ot_es
tots46654123t_ot__s
towels94314643t_owels
toyos87519143t_o_yos
toys78036343t_o_y_s
trails64622513tr_ails
tramels93812493tramels
travels104711293travels
trawls94412393tr_awls
trays85623433tr_ay_s
trets55928023tret__s
treys85018213tr_ey_s
trials64319883tr_ials
tribals9610753tribals
trills64319853tr_ills
triols66117803tr_iols
tritely1039003tritely
tritons73814883tritons
troaks104410603tro_aks
trocars959043trocars
troches123715343troches
trochils1388583trochils
trocks123614633tro_cks
trogons83410723trogons
trogs67022603tro__gs
troikas1135033troikas
troilus736413troilus
trois57226093tro__is
trokes104019263tro_kes
troll54416533tro__ll
trolly94012363tro_lly
trommels12254333trommels
trompes114111623trompes
tromps104911703tro_mps
tronas63816903tro_nas
trones65629283tro_nes
troops85712783tro_ops
tropes84824353tro_pes
tropics113610653tropics
tropins93116313tropins
trot46351313trot___
troth85622203trot__h
trothed114010973trothed
trotted83711283trotted
trotter73312253trotter
trotters83310243trotters
trouble957713trouble
troubles1057203troubles
troughs11698693troughs
troupes94112853troupes
trouts66116633tro_uts
trouty95211793trouty__
trovers103713323trovers
troves94719113tro_ves
trowel94211463trowel_
trows88826183tro__ws
trowths1365023trowths
troy77429683tro_y__
trulls64110283tr_ulls
truths9449503trut_hs
uranyls1034453uranyls
urostyle11173953urostyle
urostyles12173973urostyles
zlotys18374173zloty_s

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.406440125.6
2DLD Change Limit1340271646.15621771.8
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.60827041.6
 
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.