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

123 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
drylot103740(None) 
drylots1143741drylots
brulot8912212brulot
daylit10512492daylit
diglot83014332diglot
dryest104811122dryest
dryly12538452dryl_y
ryot75528562_ry_ot
allot54933873_allot
argot67728653ar_got
armlet84118193armlet
aryl75922343aryl__
aryls87015813aryl_s
ballot84624093ballot
blot65842323__blot
brulots946223brulots
chalot113020133chalot
clot66542423__clot
coplot10518273coplot
crypt123715233cry_pt
crypto13367273crypto
dayglow1541843dayglow
daylong1233973daylong
dealt65234283deal_t
delft95623323d_elft
delt57855273d_el_t
deploy1237583deploy
depot85727923d_epot
despot93413293despot
dialog837973dialog
dicot85429093d_icot
diglots9299503diglots
diploe9810153diploe
diplont10311693diplont
divot95723073d_ivot
doblon938013doblon
dollop9259363dollop
dolor67617963d_olor
dolt56649423d_ol_t
dot47573183d___ot
doyley13487283doyley
doyly124514013doyl_y
draft95526683dr_aft
dragon838843dragon
drat56247833dr__at
dreamt94615713dreamt
drest65530343dr_est
driblet103712243driblet
driest74722753driest
drift95722843dr_ift
drill64718263dril_l
drills74414203drills
drily95816523dril_y
dript86923873dr_ipt
droit65127123dr_oit
droll65415403drol_l
drolls75312393drolls
drolly105411673drolly
dromon939363dromon
drool65416103dr_ool
drools74412813drools
drooly104911073drooly
droop85814823dr_oop
drop75324403dr__op
droplet10312113droplet
dropout10410003dropout
dropt86924433dr_opt
dry76526033dry___
dryad10477583dry_ad
dryads11436623dryads
dryer95111463dry_er
dryers10449273dryers
drying113411603drying
dryish1336323dryish
dryland1254303dryland
drypoint1444793drypoint
drys86314803dry__s
duolog835803duolog
dwelt94316523dwel_t
ergot65422893er_got
fylfot1545043_fylfot
giglot84013133giglot
griot65328413gr_iot
grot55942053gr__ot
guyot9314523guy_ot
hallot95426783hallot
harlot94422803harlot
hayloft1696963hayloft
helot85332683_helot
lot38179263___lot
marplot1149673marplot
merlot83217603merlot
nylon82910513_nylon
ocelot8813383ocelot
orlon5415003or_lon
orlop7410903or_lop
phylon14318033phylon
pilot77435063_pilot
plot66141233__plot
prolog94212973prolog
prutot8311823prutot
pylon103614003_pylon
relet54749823_relet
relit55340683_relit
replot83818593replot
repot75132623_repot
riot45947213_r_iot
robot7325973_robot
root45655923_r_oot
rot37282953_r__ot
ryots85313783_ry_ots
skylit1338283skylit
slot46049833__slot
stylet94018573stylet
sublot82315523sublot
tricot8317753tricot
trot46351313tr__ot
tryout9410753tryout
tryst84716223try_st
wryest12429113wryest
wryly14356703wryl_y
xylol1546133_xylol
zealot15313473zealot

Search took 6 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.373479064.3
2DLD Change Limit1127161234.61024450.3
3Display Results1231230.0333727.3
 (SQL Overall)1786911235.01635624.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.