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

126 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
enrolling108773(None) 
unrolling1078561unrolling
carolling1259412carolling
drolling103510762_drolling
enfolding1444832enfolding
ennobling1244122ennobling
enrobing1137432enro_bing
enrooting10128132enrooting
enscrolling1452282enscrolling
ensouling1046002ensouling
entoiling1038482entoiling
extolling1744622extolling
knolling13206892kn_olling
reenrolling1242702reenrolling
rerolling102210372rerolling
rolling83620412__rolling
scrolling12187802scrolling
strolling10238792strolling
trolling93212492_trolling
annulling1045003annulling
anvilling1336833anvilling
bankrolling1852303bankrolling
bolling103820883__bolling
broiling113112013_broiling
caroling113317003caro_ling
controlling1445423controlling
dolling93817373__dolling
drilling103311983_drilling
drooling102610423_drooling
earthling1346193earthling
embroiling1544543embroiling
enabling1138603en_abling
enameling1246123enameling
enamelling1344313enamelling
enclosing1257573enclosing
encoding1239043enco_ding
encoring11312173enco_ring
endorsing1147303endorsing
endowing13178173endo_wing
enforcing1545473enforcing
engilding1244483engilding
engorging1244873engorging
engrailing1244853engrailing
engrossing12124643engrossing
engulfing1443353engulfing
enhaloing1345363enhaloing
enisling949633en_isling
enjoining1745053enjoining
enjoying1935003enjo_ying
enraging1049573enr_aging
enriching1546153enriching
enroll61110073enroll___
enrolled967963enroll_ed
enrollee878343enroll_ee
enrollees974323enrollees
enroller867183enroll_er
enrollers976173enrollers
enrollment1245643enrollment
enrolls7108093enroll__s
enrolment1148473enrolment
ensiling9410723en_siling
entailing1039393entailing
enthralling1543843enthralling
entitling1037103entitling
entombing1444893entombing
enwombing1742943enwombing
equalling1945243equalling
erlking1236703e_r_lking
eroding9314273e_ro_ding
evolving1533433e_volving
excelling1935643excelling
expelling1936133expelling
ferrelling1445063ferrelling
frilling123011493_frilling
grilling103811533_grilling
growling1348163_growling
infalling1356243infalling
infolding1445413infolding
inholding1445113inholding
inscrolling1452443inscrolling
insouling1036823insouling
involving1644363involving
inwalling1385633inwalling
kennelling1573863kennelling
kernelling1584143kernelling
knelling13319023kn_elling
logrolling1243063logrolling
lolling83415773__lolling
misenrolling1552093misenrolling
nilling83619563_n_illing
noodling10209443_noodling
nulling83818063_n_ulling
outrolling1137533outrolling
paroling113316213paro_ling
patrolling1345693patrolling
pencilling1545473pencilling
perilling12410003perilling
polling102920383__polling
prilling113413413_prilling
prowling1449993_prowling
redrilling1246073redrilling
repolling122110203repolling
rilling84023623__rilling
roiling83220453__roiling
rolfing113710653__rolfing
rollings9419953__rollings
shrilling13307693shrilling
snelling93913563sn_elling
snooling93013473sn_ooling
snoozling19314343snoozling
thralling13256833thralling
thrilling13276693thrilling
tolling83418563__tolling
trilling92815963_trilling
trollings10286693_trollings
trollying1354053_trollying
unbolting1236453unbolting
uncoiling1238993uncoiling
unfolding1436063unfolding
unmolding1335823unmolding
unreeling1038983unreeling
unrobing1138063unro_bing
unroofing1385703unroofing
unrooting1098833unrooting
unselling10810333unselling
unwilling1337163unwilling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411267.67019379.5
3Display Results1261260.0462739.1
 (SQL Overall)1786911268.13921954.9
 
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.