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

487 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
harlots10341329(None) 
harlot94422801harlot_
allots64019172_allots
argots74116022_argots
ballots94116032ballots
barlows12259972barlows
carrots9714622carrots
chariots1339392chariots
halloas104318462halloas
halloes104021522halloes
halloos103716742halloos
hallos95425102hallo_s
hallot95426782hallot_
halloth134111252halloth
hallows134417392hallows
haloes94623862ha_loes
halons95720712ha_lons
halos85230252ha_lo_s
halts85230102ha_l_ts
hamlets123211402hamlets
haplonts1345772haplonts
harbors12412412harbors
haricots1347332haricots
harlotry1443402harlotry
harls85634502harl__s
harrows132611032harrows
harslets1137832harslets
harts88441592har__ts
haslets102510862haslets
haylofts1783032haylofts
helots95217702h_elots
heriots10312062heriots
marmots11311512marmots
marplots1245632marplots
merlots92710122merlots
parlors9312912parlors
parlous9414292parlous
parrots9312742parrots
shallots11319502shallots
tarots66422992tar_ots
varlets10411572varlets
abbots1039283_abbots
aglets73915683_aglets
allods73615083_allods
allot54933873_allot_
allows94517683_allows
alloys94014563_alloys
aloes54933673_a_loes
altos55822953_a_ltos
alts46639903_a_l_ts
arbors84717883_arbors
ardors74416873_ardors
argols74514613_argols
argons75018203_argons
argot67728643_argot_
arhats9312973_arhats
arles56735743_arl_es
armets84918353_armets
armlets94610063_armlets
armors85017813_armors
arrows92813483_arrows
arsons63917213_arsons
arts49650263_ar__ts
arvos86015663_arvo_s
ascots85312513_ascots
azlons154110423_azlons
bailors93212413bailors
bailouts1036613bailouts
ballets93719513ballets
ballons93916963ballons
ballot84624093ballot_
barbets114915843barbets
barbuts11439843barbuts
barhops14288113barhops
barless94317003barless
barleys125011843barleys
barlow112911423barlo_w
barons85025383bar_ons
barrets94917103barrets
barrows123411683barrows
baryons121010473baryons
blots75626173__blots
brulots946223brulots
burbots1168673burbots
cablets114216343cablets
cahoots1238473cahoots
callets93821703callets
callous93516603callous
calos74431903ca_lo_s
camlets114314623camlets
caplets114914523caplets
carats85929023car_ats
carbons115418943carbons
carbos105122263carbo_s
carboys144711783carboys
cardons104519933cardons
carets85330773car_ets
cargoes104415223cargoes
cargos94619183cargo_s
carhops14329703carhops
carious93320283carious
carles85435083carl_es
carless95118493carless
carlins93921913carlins
carload1039783carload
carloads1138393carloads
carls77037423carl__s
carnets93918403carnets
carobs104818103car_obs
carols85124983car_ols
carolus94612603carolus
caroms105619573car_oms
carpets113915333carpets
carports1238943carports
carroms11512403carroms
carrot8423123carrot_
carroty1248943carroty
cartons94122473cartons
carts78946293car__ts
chalets122813473cha_lets
challot123613263challot_
challoth16316103challoth
chalot113020133cha_lot_
chaloth15298603cha_loth
chaplets1556883chaplets
chariot12316213chariot_
charleys1695633charleys
charlies133414233charlies
charlock1944393charlock
charlocks2044073charlocks
charlotte1443793charlotte
charlottes1543823charlottes
charpoys1834533charpoys
charros124312143charro_s
charts115823093char__ts
cheroots1348193cheroots
clots75627643__clots
coplots11511593coplots
darts67635733dar__ts
diglots9299503diglots
drylots1143743drylots
eaglets84111663eaglets
earlaps936393earlaps
earldoms1144223earldoms
earless74316073earless
earlobe946543earlobe
earlobes1056143earlobes
earlock1336923earlock
earlocks1435693earlocks
earls56127513earl__s
earshots1146623earshots
enroots738713enroots
ergots74512373_ergots
faggots1234853faggots
fagots1039963fa_gots
fallouts1137883fallouts
fallows133713973fallows
farles96025783farl_es
farls85731113farl__s
faros85532023far_o_s
farrows13259783farrows
farts88336843far__ts
faults94513553faul_ts
galiots82311323galiots
gallets83517403gallets
galliots9228683galliots
gallons83015953gallons
galloots9268963galloots
gallops103211653gallops
gallous82813953gallous
gallows113513513gallows
galoots82410793galoots
galops94712623ga_lops
garcons102411643garcons
gargets94614573gargets
garlics1038013garlics
garnets84115403garnets
garote7717943gar_ote
garotes8614563gar_otes
garrets84413623garrets
garrons82713463garrons
garrote8510103garrote
garrotes969363garrotes
gaults74112783gaul_ts
gavots1038103ga_vots
giglots9367863giglots
griots74713643_griots
grots65025853_gr_ots
habits113014653ha_bits
haboobs1495463haboobs
hadrons113314303hadrons
haets86525123ha__ets
haffets1636053haffets
haffits1636193haffits
hafts116219463ha__fts
hagbuts1354923hagbuts
hagdons1258523hagdons
hailers104017263hailers
hails85231643hail__s
haints94417583ha_ints
haircloth1752983haircloth
haircloths1852463haircloths
haircuts1343663haircuts
hairdos1136823hairdo_s
hairless1157413hairless
hairlock1754023hairlock
hairlocks1863773hairlocks
hairnets1195633hairnets
halals95018313ha_lals
halers94926913ha_lers
hales85449843ha_l_es
halest94823273ha_lest
halids104016133ha_lids
halite93624233ha_lite
halites103221193ha_lites
halitus10339963ha_litus
hallahs133912463hallahs
hallels103310133hallels
hallo85127553hallo__
halloa94918123hallo_a
halloed113314913halloed
halloo95118973hallo_o
hallow124818323hallo_w
halls85633783ha_l_ls
halmas117017893ha_lmas
halms105225213ha_l_ms
halo76437323ha_lo__
haloed104717603ha_loed
haloid104317763ha_loid
haloids113012553ha_loids
halon86124863ha_lo_n
halt76056303ha_l_t_
halutz1868853ha_lutz
halvas124714173ha_lvas
halves124717093ha_lves
hamlet113722793hamlet_
hamulous1344923hamulous
handouts1238233handouts
hangouts1236183hangouts
hansoms12238523hansoms
hants86335403ha__nts
haoles94919803haol_es
hapless123311333hapless
haplite12310703haplite
haplites1339993haplites
haploid1339833haploid
haploids1437363haploids
haplont12412563haplont
haploses1338853haploses
haplosis1347093haplosis
harass9313943har_ass
harbor11410723harbo_r
harbour1247053harbour
harbours1346923harbours
hardass1139753hardass
hardboots1544353hardboots
hardens113815023hardens
hardest113118413hardest
hardhats1546833hardhats
hardies114923233hardies
hards96435653har__ds
hardtop1345053hardtop
hardtops1444843hardtops
hareems12428203hareems
harelips1345213harelips
harems115513823har_ems
hares86255543har__es
haricot12311963haricot_
harkens144112863harkens
harks126333433har__ks
harl75740003harl___
harlotries1345683harlotries
harmers124116593harmers
harmins123716723harmins
harmless1337403harmless
harmony1538173harmony
harms106829013har__ms
harness102413933harness
harpers124916203harpers
harpies123818313harpies
harpins123615703harpins
harpist12312353harpist
harpists1338103harpists
harpoon1238313harpoon
harpoons1337473harpoons
harps105926863har__ps
harries103525493harries
harrow122610773harro_w
harslet10315653harslet_
hart76865773har__t_
hartals10313023hartals
harvest132112753harvest
harvests14246173harvests
haslet93222713haslet_
hatless103813443hatless
hats76858253ha___ts
haulers104012443haulers
haulms11558503haul_ms
hauls86123733haul__s
haunts95614393ha_unts
haviors1347383haviors
havocs1435653ha_vocs
hayloft1696963hayloft
haymows1883813haymows
hazmats2136603hazmats
hearts96218943hear__ts
helloes103717463helloes
hellos95321683hello_s
helos84928063h_elo_s
helot85332683h_elot_
heriot9422343heriot_
herls85226433herl__s
hermits12312143hermits
heroes94923823her_oes
herons94820543her_ons
heros84930863her_o_s
hilloas104413553hilloas
hilloes103815963hilloes
hillos94618893hillo_s
hilts86924413h_il_ts
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hollo_s
hollows134412333hollows
holts85627913h_ol_ts
hoots84830243h__oots
hornets104113553hornets
horrors1078693horrors
horsts95817513hor_sts
hots78349323h___ots
howlets13329223howlets
hulloas103911913hulloas
hulloes104113923hulloes
hulloos104010073hulloos
hullos94916293hullo_s
hurlers103714323hurlers
hurleys13407333hurleys
hurlies103315333hurlies
hurls86522713hurl__s
hursts97213093hur_sts
hurts86922823hur__ts
jabots1538883ja_bots
jailors14328753jailors
jalops15329593ja_lops
jargons1558203jargons
jarldoms1842943jarldoms
jarls126120963jarl__s
karats106420493kar_ats
karoos102415803kar_oos
kaross101910013kar_oss
karroos1139313karroos
karsts106012943kar_sts
karts97630113kar__ts
lardons83914493lardons
largos74815063largo_s
lariats7615053lariats
lots47652093___lots
maggots1136553maggots
magots9312363ma_gots
maillots1037473maillots
mallets93318493mallets
mallows123714323mallows
maloti8313203ma_loti
malts76331753ma_l_ts
markets133314033markets
marlins93420473marlins
marlite92917073marlite
marlites103415263marlites
marls75535163marl__s
marmot10318743marmot_
maroons92615553maroons
marplot1149673marplot_
marrons93216973marrons
marrows122911813marrows
martlets103310483martlets
marts77442233mar__ts
mascots113910343mascots
matelots1047533matelots
merlons93311273merlons
merlot83217603merlot_
narcos86714203narco_s
narrows10258843narrows
oarless73913373oarless
oarlock1336123oarlock
oarlocks1445103oarlocks
ocelots977233ocelots
orlons6411013_orlons
orlops847303_orlops
palets85122313pa_lets
pallets93919303pallets
pallors9314363pallors
pardons103817623pardons
parents93418123parents
pareos87023773pareo_s
pargets105215193pargets
pargos95719043pargo_s
parlays123910453parlays
parles86334403parl_es
parleys125212373parleys
parlor8312673parlo_r
parlour937263parlour
parlours1036153parlours
paroles95025883paroles
parols84722613par_ols
parous84024163par_ous
parrot8320663parrot_
parroty1247863parroty
parsons93516873parsons
partlets102811513partlets
partons94620513partons
parts77743373par__ts
parvos116614753parvo_s
patriots1038053patriots
pharaohs1644493pharaohs
pharos11312063phar_o_s
pilots84018873_pilots
plots75025673__plots
reallots837993reallots
replots93412633replots
riots54922013__riots
roots55933673__roots
rots46454093__r_ots
ryots85313783__ryots
sabots8314693sa_bots
sailors73213723sailors
sallets73719653sallets
sallows103915553sallows
salols64017873sa_lols
salons63823693sa_lons
salts55431883sa_l_ts
samlets93813553samlets
sandlots938293sandlots
sarcous9312933sarcous
sargos74318273sargo_s
sarods74918573sar_ods
saros55238063sar_o_s
sartors7314963sartors
saults65816173saul_ts
sawlogs1135393sawlogs
scarlets10178573scarlets
shallops13288323shallops
shallot103614133shallot_
shallows14388863shallows
shaloms1288983sha_loms
sheroots1137863sheroots
slots54830523__slots
starlets81610083starlets
sublots92410913sublots
tablets94714373tablets
tailors73212393tailors
tallits73215993tallits
tallols73311363tallols
tallows103313743tallows
talons64019433ta_lons
taproots1047253taproots
targets84314223targets
tarocs84615663tar_ocs
taroks106115283tar_oks
taros55640823tar_o_s
tarot55943933tar_ot_
tarpons92612203tarpons
tartlets8289663tartlets
tarts57242023tar__ts
thallous1136523thallous
trots56629943_tr_ots
turbots988023turbots
unroots738563unroots
uproots937143uproots
valets93715623va_lets
valors93413773va_lors
various103113103various
varlet9423503varlet_
varooms1248883varooms
vaults94511673vaul_ts
wallets103914833wallets
wallops123410413wallops
wallows133613533wallows
warless104015103warless
warlock1636293warlock
warlocks1735363warlocks
warlord1136293warlord
warlords1245303warlords
warts814840403war__ts
whatnots1442303whatnots
yarrows13277853yarrows
zealots1636763zealots

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340274876.56320421.6
3Display Results4874870.1732815.0
 (SQL Overall)1786914876.87625987.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.