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

209 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
enroll6111007(None) 
enrol51014281enro_l
enrolls7108091enrolls
enrols61213381enrols
unroll61210071unroll
bedroll1055552bedroll
droll65415402_droll
enfold10137612enfold
enol45823822en_o_l
enols54718402en_ols
enrobe86610792enrobe
enrolled967962enrolled
enrollee878342enrollee
enroller867182enroller
enroot6615992enroot
enscroll1093332enscroll
ensoul638252ensoul
entoil6912492entoil
extoll1334862extoll
knoll9389602kn_oll
nerol51017812nero_l
neroli61111152neroli
nerols6914882nerols
reenroll843542reenroll
reroll6412682reroll
roll46331652__roll
scroll8310162scroll
stroll6311602stroll
troll54416532_troll
unrolls797792unrolls
anole55330373an_ole
antiroll847763antiroll
atoll57913923_atoll
bankroll1443493bankroll
beadroll1144503beadroll
bedrolls1144673bedrolls
benzol1756993benzo_l
benzole1837133benzole
benzols1836673benzols
benzoyl2143363benzoyl
boll65634753__boll
brill74819953_brill
broil74918223_broil
brolly114510853_brolly
carol75128613caro_l
caroli85918233caroli
carols85124983carols
corolla938623corolla
doll56632493__doll
drill64718263_drill
drolls75312393_drolls
drolly105411673_drolly
drool65416103_drool
earful958963earful
earl45838143ear__l
earls56127513ear_ls
early85324123ear_ly
eerily92913563eerily
eidola737683eidola
ell36735683e___ll
emboli1037473emboli
emboly1336713emboly
embroil1146613embroil
enable83318483enable
enamel81210113enamel
encode9310443encode
encore8314773encore
endow94510983endo_w
endows104610423endows
enfolds11136253enfolds
engild8107613engild
engrail846253engrail
engross837123engross
engulf1038883engulf
enhalo987563enhalo
enisle63412093enisle
enjoin1357833enjoin
enjoy1545963enjo_y
enjoys1644603enjoys
ennoble935633ennoble
enoki9268873en_oki
enolic8413353en_olic
enorm74415633en_orm
enow77819873en_o_w
enows85115493en_ows
enrage72715073enrage
enrapt8313013enrapt
enrich1138943enrich
enrobed10279253enrobed
enrober9218613enrober
enrobes92211113enrobes
enrollees974323enrollees
enrollers976173enrollers
enrolling1087733enrolling
enroots738713enroots
enscrolls1192523enscrolls
ensile62616473ensile
ensouls736033ensouls
entail61114343entail
enthrall11266833enthrall
entoils7810733entoils
entomb1037363entomb
entropy1247353entropy
envoi878023envo_i
envois988703envois
envoy1156713envo_y
envoys1255133envoys
enwomb1344973enwomb
erode64520993e_rode
eros45238453e_ro_s
erose55727273e_rose
error53712233erro_r
errors63311313errors
ervil8310303e_rvil
euro45325273euro__
euroky1334823euroky
euros54920243euro_s
extol1247893exto_l
extolls1444603extolls
extols1337683extols
frill84917563_frill
genro64914033genro__
genros74211333genro_s
girolle835793girolle
grill64617893_grill
growl96115823_growl
indol63714873indo_l
indole74516053indole
indols74714203indols
infall939403infall
infill938403infill
infold10128163infold
inro45920793inro__
inroad737933inroad
inscroll10113213inscroll
insole63515863insole
insoul638463insoul
inwall938343inwall
knell94210923kn_ell
knolls10367413kn_olls
knolly13336133kn_olly
krill94213643_krill
logroll844263logroll
loll46128383__loll
menfolk1643883menfolk
misenroll1152523misenroll
moll66735703__moll
nerolis71012773nerolis
nill45634303_n_ill
noel45226553_n_oel
noil46133243_n_oil
nolo46229313_n_olo
null45125313_n_ull
outroll749303outroll
parol74826273paro_l
parole84425253parole
parols84722613parols
payroll1245613payroll
petrol82714063petro_l
petrols92913083petrols
poll66332133__poll
prill74117943_prill
prole74527793_prole
prowl105615123_prowl
pyrola1139003pyrola
quoll14379493_quoll
redpoll1045043redpoll
redrill857893redrill
reenrolls942993reenrolls
repoll8410793repoll
rerolls739943rerolls
rill45140903__rill
roil46235293__roil
role45851823__role
rolf75134873__rolf
rolls55326233__rolls
rotl45029683__rotl
scrolls938063scrolls
shrill94712303shrill
snell54517303sn_ell
snool55118643sn_ool
snools65715873snools
strolls739183strolls
tenfold1145713tenfold
thrall93810293thrall
thrill94910593thrill
toll45535263__toll
trill55122933_trill
trolls64613943_trolls
trolly94012353_trolly
trull54012673_trull
unbolt83013893unbolt
uncoil8811853uncoil
uncool8610113uncool
unfold10179703unfold
unholy1238163unholy
unmold9148313unmold
unreal64414453unreal
unreel63612933unreel
unrobe82611673unrobe
unrolled9610413unrolled
unroof9410193unroof
unroot6315553unroot
unrove92511683unrove
unruly938083unruly
unsell63512543unsell
unsold71410513unsold
untold7149683untold
unwell9349443unwell

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127162097.80014450.8
3Display Results2092090.0603483.3
 (SQL Overall)1786912097.98322383.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.