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

125 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
follower1413707(None) 
followed15146271followed
followers15146181followers
hollower14127401hollower
bellower13159072bellower
callower13159072callower
fallowed15127752fallowed
fellowed15136842fellowed
flower124815502f__lower
follow124010352follow__
follows13409922follow_s
followup1642172followup
hallower14139822hallower
hollowed15157032hollowed
mellower13167412mellower
rollover1144452rollover
sallower11139502sallower
wallower14158942wallower
willower14127462willower
yellower14186222yellower
allover1038583_allover
allowed111610083_allowed
balloter1078893balloter
beflower16166283beflower
bellowed14158613bellowed
bellowers14177623bellowers
billowed14137063billowed
billowier1444293billowier
blower115316573__blower
boilover1344023boilover
bolloxed1834473bolloxed
bolloxes1736833bolloxes
borrower1384843borrower
colleger11227933colleger
collider113410423collider
collier93618153coll_ier
colluder11276873colluder
colorer9312523co_lorer
deflower15126083deflower
dolloped1234983dolloped
falconer1346043falconer
faller94621233fall__er
fallow124713853fallow__
fallows133713973fallow_s
feller94419553fell__er
felloe93513923fello_e_
felloes104114383fello_es
fellow123712743fellow__
fellowly17264093fellowly
fellowmen1742923fellowmen
fellows134212433fellow_s
filler94623623fill__er
flooder11258463f_looder
floorer10248073f_loorer
flopover1642863flopover
flowed133513763f__lowed
flowers133413173f__lowers
flowery16327783f__lowery
flyover1633513f_lyover
foamflower2152113foamflower
folder104317543fo_l_der
folioed1138033folio_ed
foliose10378013foliose_
folkier14359043fo_lkier
folklore1543473folklore_
folklores1643703folklores
folksier1533533folksier
folles93820473foll__es
follies103618943foll_ies
following1665753following
followups1742293followups
footer94320773fo__oter
forgoer1137693forgo_er
forlorner1243123forlorner
fouler93614903foul__er
fowler123712583fowl__er
fuller94220383full__er
furrower1464043furrower
galloper11137193galloper
glower105114933__glower
hallowed15179503hallowed
hallowers15137723hallowers
holdover1544083holdover
holler93520613holl__er
holloaed12157393holloaed
holloed113812753hollo_ed
holloes103818193hollo_es
hollooed12146493hollooed
hollow124212663hollow__
holloware1543943holloware
hollowest1544903hollowest
hollowly1743383hollowly
hollows134412333hollow_s
jollier142911003joll_ier
kotower1434383ko_tower
kowtower1842273kowtower
loller63315283loll__er
lolloped1134463lolloped
lower85830413___lower
mellowed14166933mellowed
pillowed14156383pillowed
plower114315063__plower
poller83921853poll__er
pollster1037103pollster
polluter1035403polluter
pullover13134643pullover
reflower14126853reflower
roller63919793roll__er
rollovers1244093rollovers
sallowed12149033sallowed
shallower1555683shallower
slower94016153__slower
sorrower1165053sorrower
swallower1554333swallower
tallowed12157713tallowed
toller63819443toll__er
volleyer1443163volleyer
walloper13147113walloper
wallowed15148173wallowed
wallowers15127653wallowers
willowed15156773willowed
willowers15166693willowers
willowier1563783willowier
willpower1773193willpower
yellowed15185753yellowed

Search took 8 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.440406115.9
2DLD Change Limit1461621257.00020880.3
3Display Results1251250.0602083.3
 (SQL Overall)1786911257.50023825.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.