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

149 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
hovelling163616(None) 
hoveling15189591hove_ling
shovelling1744061shovelling
bevelling15227452bevelling
bowelling1566492bowelling
covelline1446532covelline
dowelling1466252dowelling
gavelling14286872gavelling
grovelling1554162grovelling
helling114623222h__elling
hostelling1446162hostelling
houselling1445752houselling
hovering151911142hove_ring
kvelling16146512_kvelling
levelling13206972levelling
modelling1336882modelling
ravelling13269242ravelling
revelling132412552revelling
rowelling1366992rowelling
shoveling1635552shove_ling
towelling1366252towelling
yodelling1435192yodelling
anvilling1336833anvilling
belling103825073__belling
beveling143011033beve_ling
bolling103820883bo__lling
boweling143410683bowe_ling
cavilling1536383cavilling
celling103921263__celling
chiselling1644683chiselling
compelling1746553compelling
corbelling1546713corbelling
cordelling1446383cordelling
covellines1545303covellines
covellite1445603covellite
covering142215723cove_ring
coveting141912303cove_ting
cupelling1436283cupelling
develing133212733deve_ling
devilling1436703devilling
dolling93817373do__lling
dovening13238353dove_ning
doweling13279763dowe_ling
drivelling1543983drivelling
duelling103410733_duelling
dwelling13368413_dwelling
excelling1935643excelling
expelling1936133expelling
felling113321133__felling
fuelling123410153_fuelling
gaveling133410163gave_ling
gelling93219763__gelling
governing1435533governing
gravelling1565213gravelling
groveling1435573grove_ling
gruelling1155603gruelling
hanselling1445623hanselling
havening15258553have_ning
havering152211053have_ring
healing113922963h__ealing
heeling113618513h__eeling
heiling113616363h__eiling
helloing12159123h__elloing
helming133712003h__elming
helping133512223h__elping
helving144011133h__elving
hilling113821773h__illing
hireling121210993hire_ling
hirselling1444833hirselling
hobbling16227583ho_bbling
hoeing104117023ho_e__ing
holding123514283ho__lding
holing104025073ho___ling
holking153512313ho__lking
hollaing12167093ho_llaing
hollering1337743hollering
holloing12148823ho_lloing
homering141512073home_ring
hondling132210013ho_ndling
honeying1537673hone_ying
hoovering1635753hoove_ring
hoppling16206763ho_ppling
hoseying1537193hose_ying
hosteling1337893hosteling
houseling1337483houseling
hovelled15146843hovell_ed
howling143413163ho__wling
hulling113619013h__ulling
impelling1436913impelling
jelling153516613__jelling
jewelling2034833jewelling
knelling13319023_knelling
labelling1238073labelling
leveling122910433leve_ling
libelling1236873libelling
lolling83415773lo__lling
marvelling1645363marvelling
melling102822623__melling
modeling12311073mode_ling
monellin1047373monellin_
monellins1147413monellins
morselling1346323morselling
novelising1444893novelising
novelizing2345273novelizing
overing111918053_ove_ring
overlong1238123_overlong
overlying1638003_overlying
panelling1239073panelling
polling102920383po__lling
pommelling1743613pommelling
propelling1556933propelling
quelling18259793_quelling
raveling123414373rave_ling
ravellings14214453ravellings
rebelling122111163rebelling
refelling132211313refelling
repelling122312753repelling
reselling102213833reselling
retelling102112493retelling
revealing132611883revealing
reveling123117083reve_ling
rivalling1335963rivalling
rolling83620413ro__lling
roweling122811123rowe_ling
selling83225833__selling
shaveling1646843shave_ling
shelling123515213_shelling
shrivelling1842213shrivelling
smelling113712723_smelling
snelling93913563_snelling
snivelling1444293snivelling
spelling113315233_spelling
swelling123212753_swelling
swivelling1743413swivelling
telling83321083__telling
tolling83418563to__lling
totalling1036513totalling
toweling122910373towe_ling
towellings1452893towellings
travelling1456533travelling
trowelling1484913trowelling
unselling10810333unselling
unveiling1337723unveiling
upwelling1535233upwelling
vealing114217423__vealing
veiling113615293__veiling
welling112920313__welling
yelling113516703__yelling
yodeling1357673yode_ling

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411498.90616690.0
3Display Results1491490.0602483.3
 (SQL Overall)1786911499.13919552.6
 
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.