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

113 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
enroller86718(None) 
enrolled967961enrolled
enrollee878341enrollee
enrollers976171enrollers
caroller1039202caroller
droller84110282_droller
enfolder1286152enfolder
ennobler1043542ennobler
enrober9218622enro_ber
enroll61110072enroll__
enrollees974322enrollees
enrolls7108092enroll_s
extoller1564182extoller
knoller11285912kn_oller
reroller8258752reroller
roller63919792__roller
stroller848182stroller
troller73913172_troller
unrolled9610412unrolled
bankroller1662363bankroller
broiler92911753_broiler
caroler93816753caro_ler
carolled1138833carolled
carollers1137703carollers
controller1245523controller
cruller968753_cruller
driller84311883_driller
drolled93810223_drolled
drollery12314793_drollery
earlier72612743ear_lier
embroiler1344093embroiler
enabler9299363en_abler
enameler1045883enameler
enameller1144173enameller
encloser10107183encloser
encoder1038633enco_der
endorser966733endorser
endower1138483endo_wer
enfolded1345433enfolded
enfolders1395093enfolders
enforcer13246503enforcer
engrosser1043843engrosser
enjoiner15225653enjoiner
enjoyer1744383enjo_yer
ennoble935633ennoble_
ennobled1143833ennobled
ennoblers1143193ennoblers
ennobles1045113ennobles
enricher1345003enricher
enrobe86610793enro_be_
enrobed10279253enro_bed
enrobers10236953enro_bers
enrobes92211113enro_bes
enrol51014283enro_l__
enrolling1087733enrolling
enrollment1245643enrollment
enrolment1148473enrolment
enrols61213383enro_l_s
enrooted977423enrooted
enscrolled1342553enscrolled
ensouled935833ensouled
entailer877833entailer
entoiled968283entoiled
eviller1056673e_viller
evolver13275803e_volver
expeller17105793expeller
extolled1654313extolled
extollers1663853extollers
friller104111743_friller
girolle835793girolle_
girolles935523girolles
griller84513353_griller
growler11318973_growler
holler93520613__holler
infolder1256433infolder
inholder1276113inholder
involver1444663involver
knolled12296573kn_olled
knollers12255143kn_ollers
kruller1145153_kruller
logroller1042443logroller
loller63315283__loller
nobler83713453_n_obler
patroller1145743patroller
penciller1344953penciller
penholder1544413penholder
poller83921853__poller
prowler123310013_prowler
reenrolled1143033reenrolled
rerolled93010053rerolled
rerollers9207123rerollers
rolfer94412273__rolfer
rolled74220243__rolled
rollers73117473__rollers
scrolled1137053scrolled
shriller1136823shriller
sneller73512853sn_eller
strolled937823strolled
strollers937553strollers
thriller1165553thriller
toller63819443__toller
triller74215893_triller
trolled84312263_trolled
trollers83211213_trollers
trolley10328753_trolley
unfolder12216583unfolder
unholier1137283unholier
unpolled1168943unpolled
unreeler8127293unreeler
unroll61210073unroll__
unrolls797793unroll_s
unrulier845333unrulier
unsolder937213unsolder

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621136.50022486.5
3Display Results1131130.0462456.5
 (SQL Overall)1786911136.96925640.8
 
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.