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

102 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
hulloaed1210580(None) 
halloaed121510151halloaed
hilloaed12136921hilloaed
holloaed12157391holloaed
hulloed11369791hullo_ed
hullooed12135091hullooed
halloed113314912hallo_ed
hallooed12168772hallooed
hallowed15179492hallowed
helloed113512422hello_ed
hilloed113211292hillo_ed
hollaed11359852holl_aed
holloed113812752hollo_ed
hollooed12146492hollooed
hollowed15157022hollowed
hulled103920012hull__ed
hulloa95011182hulloa__
hulloas103911912hulloa_s
hulloes104113922hullo_es
allowed111610083_allowed
alloyed11158033_alloyed
balloted1189043balloted
bellowed14158603bellowed
billowed14137063billowed
bolloxed1834473bolloxed
bullae83416163bull_ae_
bulldozed2242233bulldozed
bulled94626493bull__ed
bulleted1138393bulleted
bullhead1464783bullhead
bullied104514813bull_ied
bullweed1444753bullweed
busload1044683busloa_d
culled94022473cull__ed
cullied104012353cull_ied
cupolaed1342753cupolaed
dolloped1234983dolloped
dullard936603dull_ard
dulled84719423dull__ed
fallowed15127753fallowed
fellowed15136833fellowed
followed15146273followed
fulled103820653full__ed
fullered1236383fullered
galloped12107143galloped
gulled84521373gull__ed
gullied93812063gull_ied
halliard12125963halliard
halloa94918123halloa__
halloas104318463halloa_s
halloes104021523hallo_es
hallower14139813hallower
haloed104717603h_alo_ed
helled104024703hell__ed
helloes103717463hello_es
hilled104022223hill__ed
hilloa94713033hilloa__
hilloas104413553hilloa_s
hillocked1942793hillocked
hilloes103815963hillo_es
holland11349473holl_and
hollered1237603hollered
holloa94914823holloa__
holloas103814943holloa_s
holloes103818193hollo_es
hollower14127393hollower
hulked144611303hu_l_ked
huller93919103hull__er
hullo84417453hullo___
hulloaing1384523hulloaing
hulloing12146703hulloing
hulloo94511733hullo__o
hulloos104010073hullo_os
hullos94916293hullo__s
humored1336723hu_mored
hurled104617453hurl__ed
huzzaed1943103hu_zzaed
lolloped1134463lolloped
lulled74516443lull__ed
mellowed14166923mellowed
mulled94721553mull__ed
mullioned1245733mullioned
nulled74318273null__ed
outloved12248583outloved
pillowed14156383pillowed
pulled94322193pull__ed
pullover13134643pullover
sallowed12149033sallowed
shallowed1655083shallowed
sullied83714483sull_ied
tallowed12157713tallowed
ullaged937033_ullaged
unload73010803_unloa_d
unloaded1049533_unloaded
unlobed10219743_unlobed
unloved112310533_unloved
upload9257783_uploa_d
uploaded1234533_uploaded
walloped14146833walloped
wallowed15148163wallowed
willowed15156763willowed
yellowed15185743yellowed

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.453394461.4
2DLD Change Limit1461621026.31323152.5
3Display Results1021020.0462217.4
 (SQL Overall)1786911026.81226231.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.