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

343 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
hassling123680(None) 
rassling939011rassling
castling11311232castling
chasseing1554962chasseing
gassing94216332gass_ing
hackling183310162hackling
haggling14227272haggling
hailing113820692ha_iling
haling104229782ha__ling
handling132312712handling
hanseling1338062hanseling
hashing145020162ha_shing
hasping134414902ha_sping
hasting114725192ha_sting
hauling113714432ha_uling
hirsling1277542hirsling
hissing114213142hiss_ing
hustling12228792hustling
lassoing946382lassoing
massing104318022mass_ing
passing104318422pass_ing
sassing84615552sass_ing
tasseling1035852tasseling
tussling935822tussling
warsling12198592warsling
wrassling1334272wrassling
addling10229833_addling
ailing74331013_a_iling
amassing1138003amass_ing
ambling121411793_ambling
aneling82719503_aneling
angling92816043_angling
ankling122912063_ankling
argling92812733_argling
ashing107824093_a_shing
asking116017233_a_sking
assailing1036023_assailing
assaying1236003_assaying
assign736783_ass_ign
asslike1137373_asslike
assoiling1045353_assoiling
assuming1135143_assuming
assuring937773_assuring
babbling12228693babbling
baffling1756053baffling
bailing103723523ba_iling
baling94829693ba__ling
balling104424763ba_lling
bantling112612003bantling
baseline10310753baseline
bashing135422583ba_shing
basing95427663ba_s_ing
basking144718613ba_sking
basseting1236153basseting
basting104227203ba_sting
battling113110493battling
bawling133813863ba_wling
biassing11307263biass_ing
bossing103714603boss_ing
brassing112612303brass_ing
brisling112410843brisling
bussing103614623buss_ing
bustling112110063bustling
cabling124017553ca_bling
cackling172610943cackling
cageling12310843cageling
cajoling18318423cajoling
calling103826773ca_lling
canaling112016413canaling
candling122313873candling
capsuling1444533capsuling
carling103727063ca_rling
caroling113317003caroling
cashing135022553ca_shing
casing94829103ca_s_ing
casking144317353ca_sking
cassina94113163cass_ina
cassine93817283cass_ine
cassino93512433cass_ino
casting104628343ca_sting
catling104819793ca_tling
causing103614413caus_ing
caviling14310113caviling
cessing103814813cess_ing
chasing133715893cha_s_ing
chiseling1536403chiseling
classing113211793class_ing
cussing103814273cuss_ing
dabbling14227973dabbling
daddling12258233daddling
daggling12237063daggling
dandling112511733dandling
dangling112611233dangling
dappling1436843dappling
darkling1437483darkling
darling93418363da_rling
dartling1039563dartling
dashing125917893da_shing
dawdling14236373dawdling
dazzling1834363dazzling
dissing94517683diss_ing
dossing93313273doss_ing
eagling91113603ea_gling
eanling81416673ea_nling
easing74926463ea_s_ing
easting84924303ea_sting
enisling949633enisling
ensiling9410723ensiling
fabling133413623fa_bling
failing113521333fa_iling
falling113621583fa_lling
fashing144918793fa_shing
fasting114522833fa_sting
fatling113815683fa_tling
fessing113812863fess_ing
fussing113611683fuss_ing
gabbling14238073gabbling
gabling113514543ga_bling
gaggling10217463gaggling
galling93921963ga_lling
gambling14218963gambling
gangling112411403gangling
gaoling93314653ga_oling
garbling12249453garbling
gargling11239203gargling
gashing125119233ga_shing
gasking134415913ga_sking
gasoline938523gasoline
gasping113714363ga_sping
gassings10438403gass_ings
gasting95022763ga_sting
gaveling133410163gaveling
glassing10329973glass_ing
gosling93312403_gosling
grassing103311973grass_ing
gussying1334063gussying
habiting1437533habiting
hacking173720613ha_cking
hading113922943ha__ding
haeing104118923ha__eing
hafting144014173ha_fting
hagging133114683ha_gging
hairline1137873hairline
halloing121510073halloing
haloing113814133ha_loing
halting114419073ha_lting
halving143511543ha_lving
hamming153014093ha_mming
hamstring1546003hamstring
handing123518893ha_nding
handlings14237343handlings
handseling1544323handseling
hanging123518703ha_nging
hanking154619103ha_nking
hanselling1445623hanselling
hanting114124483ha_nting
happing153817233ha_pping
harassing1346983harassing
hardline12310273hardline
haring104233003ha__ring
harking154120943ha_rking
harming133717933ha_rming
harping134118383ha_rping
harrying15157643harrying
hassium1236133hass_ium
hassle93711593hassl__e
hassled11358303hassl_ed
hassles103411693hassl_es
hastening13259483hastening
hatching173312213hatching
hatchling1844953hatchling
hating104929713ha__ting
hatting113920233ha_tting
haunting123510053haunting
havening15258553havening
havering152211053havering
having134220373ha__ving
hawing134322353ha__wing
hawking183711423ha_wking
haying134420613ha__ying
hazing194218553ha__zing
healing113922963h_ealing
hearsing1239383hears_ing
heckling18257163heckling
heeling113618513h_eeling
heiling113616363h_eiling
heisting123411043heisting
helling114623223h_elling
higgling14217163higgling
hilling113821773h_illing
hireling121210993hireling
hirpling1467223hirpling
hirseling1396273hirseling
hissings12556753hiss_ings
histing113720373h_isting
hobbling16227583hobbling
hoising113414413hois_ing
hoisting123610903hoisting
holing104025073h__oling
hondling132210013hondling
hoppling16206763hoppling
horsing113215583hors_ing
hoseying1537193hoseying
hosing103421103h_os_ing
hosteling1337893hosteling
hosting114318383h_osting
houseling1337483houseling
housing113316523hous_ing
hoveling15189593hoveling
howling143413163h_owling
huddling14227293huddling
hulling113619013h_ulling
humbling16208673humbling
hurdling13288013hurdling
hurling113616413h_urling
hurtling12318313hurtling
hushing144514473h_ushing
husking154312053h_usking
isling71213883__isling
issuing836053_issuing
jailing153415843ja_iling
jangling17249623jangling
jessing153710623jess_ing
jostling16207123jostling
justling16207253justling
kissing122911053kiss_ing
labeling11311643labeling
ladling92813393la_dling
lalling83519623la_lling
lapsing103511163laps_ing
lashing114422893la_shing
lasing74727983la_s_ing
lasting84725243la_sting
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
malling103623663ma_lling
mangling122312623mangling
mantling112012613mantling
marbling13179883marbling
marling103322763ma_rling
mashing134422243ma_shing
masking145116613ma_sking
masoning1139763masoning
massaging1346353massaging
masting104325823ma_sting
mauling103315683ma_uling
messing103916393mess_ing
missing103619073miss_ing
mossing103915423moss_ing
muscling1337853muscling
mussing104015543muss_ing
nailing83419963na_iling
nestling958893nestling
nursling997603nursling
paddling13218643paddling
paling93530133pa__ling
palling104024483pa_lling
palsying1436233palsying
paneling111013623paneling
parling103823763pa_rling
paroling113316213paroling
parsing103819553pars_ing
pashing135120513pa_shing
passaging1345613passaging
passalong1242523passalong
passings11409873pass_ings
pasting103826553pa_sting
pausing103912813paus_ing
pestling111010253pestling
phasing133211673pha_s_ing
pissing103914803piss_ing
quisling18218063quisling
rabbling13239333rabbling
raddling11229773raddling
raffling1567063raffling
railing83325643ra_iling
raising83220533rais_ing
rambling131810773rambling
rankling132610113rankling
rasing74330833ra_s_ing
rasping104316253ra_sping
rattling92510873rattling
raveling123414373raveling
resiling93520173resiling
resoling92916303resoling
riesling939013riesling
rustling9249983rustling
saddling11239593saddling
sailing83927373sa_iling
sampling13510643sampling
sandling102214413sandling
sapling103217863sa_pling
sashing114621473sa_shing
shackling19286173shackling
shambling1735593shambling
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
sling66028803___sling
soling74226823__soling
sussing84013703suss_ing
tabling103216033ta_bling
tackling153211123tackling
tailing82923103ta_iling
tangling101712543tangling
tasking124616323ta_sking
tasselling1145233tasselling
tasting84624213ta_sting
tattling9259473tattling
tawsing1138673taws_ing
teaseling1036913teaseling
tissuing935103tissuing
tossing83612563toss_ing
tousling938793tousling
unsling8313643_unsling
vailing113817943va_iling
vaseline1138613vaseline
wabbling16207743wabbling
waddling14237933waddling
waffling1845423waffling
waggling14197063waggling
wailing113620903wa_iling
waisting123615213waisting
waling104525303wa__ling
walling113520973wa_lling
wambling16198443wambling
wangling132310993wangling
warbling14198943warbling
warstling1335063warstling
washing145119283wa_shing
wassailing1443593wassailing
wasting114422843wa_sting
wattling12258783wattling
wauling112713113wa_uling
wawling143810963wa_wling
weaseling1335613weaseling
whaling143910773wha__ling
whistling1644733whistling
wissing113212943wiss_ing
wrastling1335523wrastling
yawling14369183ya_wling
yessing113210063yess_ing

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461623438.06318127.5
3Display Results3433430.1562198.7
 (SQL Overall)1786913438.37521336.2
 
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.