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

181 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
hallower1413981(None) 
callower13159071callower
hallowed15179491hallowed
hallowers15137721hallowers
hollower14127391hollower
sallower11139501sallower
shallower1555671shallower
wallower14158931wallower
allover1038582_allover
allowed111610072_allowed
balloter1078892balloter
bellower13159062bellower
fallowed15127752fallowed
follower14137072follower
galloper11137182galloper
halloaed121510152halloaed
halloed113314912hallo_ed
halloes104021512hallo_es
hallooed12168772hallooed
hallow124818322hallow__
hallows134417392hallow_s
harrower1446362harrower
hollowed15157022hollowed
mellower13167402mellower
sallowed12149032sallowed
shallowed1655082shallowed
swallower1554332swallower
tallowed12157712tallowed
walloper13147112walloper
wallowed15148162wallowed
wallowers15127652wallowers
willower14127452willower
yellower14186212yellower
allayer10148213_allayer
alleger8319623_alleger
allobar946663_allobar
allotter866473_allotter
allovers1137673_allovers
allow85420663_allow__
allows94517683_allow_s
alloyed11158033_alloyed
allurer7348433_allurer
almoner949383_almoner
avower1236823_a_vower
baller83825203ball__er
ballonet10314503ballonet
balloted1189043balloted
balloters1157673balloters
ballsier1036523ballsier
beflower16166273beflower
bellowed14158603bellowed
bellowers14177623bellowers
billowed14137063billowed
billowier1444293billowier
blower115316573__blower
caller85125483call__er
calliper1247513calliper
callose9313653callose_
calloses10313383calloses
callow114714663callow__
callowest1445823callowest
caloyer1238143ca_loyer
dallier84215373dall_ier
dayflower1942543dayflower
deflower15126073deflower
falconer1346033falconer
faller94621233fall__er
fallow124713853fallow__
fallows133713973fallow_s
fellowed15136833fellowed
flower124815503__flower
followed15146273followed
followers15146183followers
galloped12107143galloped
gallopers12136323gallopers
gallows113513513gallow_s
gallowses1374943gallowses
glower105114933__glower
hailer94720343hail__er
haler85033523ha_l__er
hallel93514093hall__el
hallo85127553hallo___
halloa94918123hallo__a
halloas104318463hallo_as
halloing121510073halloing
halloo95118973hallo__o
halloos103716743hallo_os
hallos95425103hallo__s
hallot95426783hallo__t
halloth134111253hallo_th
hallowing1676943hallowing
halluces1335613halluces
hallway1636173hall_way
haloed104717593ha_lo_ed
haloes94623863ha_lo_es
halogen1138393ha_logen
halter94420883ha_l_ter
handover15126823handover
hangover15134423hangover
haploses1338853haploses
harborer1348053harborer
harrowed1556263harrowed
harrowers1555683harrowers
hauler95015123haul__er
haulier1059943haul_ier
haulmier1333143haulmier
heller93322513hell__er
helloed113512423hello_ed
helloes103717453hello_es
hiller94421633hill__er
hillier103413963hill_ier
hilloaed12136923hilloaed
hilloed113211293hillo_ed
hilloes103815943hillo_es
holdover1544083holdover
holler93520613holl__er
holloaed12157393holloaed
holloed113812753hollo_ed
holloes103818193hollo_es
hollooed12146493hollooed
hollow124212663hollow__
holloware1543943holloware
hollowest1544903hollowest
hollowly1743383hollowly
hollows134412333hollow_s
huller93919103hull__er
hulloaed12105803hulloaed
hulloed11369793hullo_ed
hulloes104113923hullo_es
hullooed12135093hullooed
lower85830413___lower
mallow114014743mallow__
mallows123714323mallow_s
manpower1544703manpower
mayflower2042723mayflower
mellowed14166923mellowed
narrower1145063narrower
pallier94417163pall_ier
pallor8313673pallo__r
pillowed14156383pillowed
plower114315063__plower
pullover13134643pullover
rallier73816273rall_ier
reflower14126843reflower
rollover1144453rollover
safflower1842993safflower
sallier73320423sall_ier
sallow94315753sallow__
sallowest1246563sallowest
sallowly14344833sallowly
sallows103915543sallow_s
sallowy13369343sallow_y
scalloper1344453scalloper
shadower1544863sha_dower
shallow13388873shallow__
shallowest1643993shallowest
shallowly1842613shallowly
shallows14388853shallow_s
slalomer1045033slalomer
slower94016153__slower
swallowed1663583swallowed
swallowers1653813swallowers
taller63721963tall__er
tallier72817213tall_ier
tallow93714203tallow__
tallows103313733tallow_s
tallowy13347633tallow_y
unallowed1344413unallowed
unhallowed1742193unhallowed
walkover1842943walkover
wallflower1952533wallflower
walloped14146833walloped
wallopers14136273wallopers
wallow123913513wallow__
wallows133613533wallow_s
warpower1645043warpower
willowed15156763willowed
willowers15166693willowers
willowier1563783willowier
willpower1773183willpower
yellowed15185743yellowed

Search took 10 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.236757165.3
2DLD Change Limit1461621819.29615723.1
3Display Results1811810.0632873.0
 (SQL Overall)1786911819.59518623.3
 
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.