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

425 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
hareems1242820(None) 
hakeems16394801hakeems
hareem114312061hareem_
harems115513821har_ems
adeems946332_adeems
careens94514702careens
careers95218782careers
haems105517012ha__ems
haeres94017032haere_s
hakeem15407382hakeem_
hardens113815022hardens
harem104924452har_em_
hares86255542har_e_s
harkens144112862harkens
harmers124116592harmers
harms106829012har__ms
harness102413932harness
harpers124916202harpers
hirees95117292hiree_s
larees65323112laree_s
sarees65329942saree_s
adeem8311803_adeem_
afreets1037013afreets
agrees74915323agree_s
akees96119243_akee_s
ameers84015573_ameers
arames84622573_arames
ardebs937013_ardebs
areas55935773_ar_eas
arecas84817443_arecas
arenas65021993_arenas
arenes64928393_arenes
arepas85515703_arepas
ares45871023_ar_e_s
aretes64425353_aretes
ariels65119373_ariels
arles56735743_arle_s
armers85520273_armers
armets84918353_armets
arms66137493_ar__ms
arpens84814823_arpens
arses55733873_arse_s
artels66216233_artels
arums75517833_ar_ums
baleens938473baleens
barbels114514433barbels
barbers114317503barbers
barbes104526233barbe_s
barbets114915843barbets
bardes95026933barde_s
bareges105212033bareges
bareness10912813bareness
bares75457133bar_e_s
bargees105415873bargees
barges94528253barge_s
bariums1139143bariums
barkeeps1634143barkeeps
barkers134318513barkers
barless94317003barless
barleys125011843barleys
barms96128463bar__ms
barneys12569563barneys
barrels94514363barrels
barrens94414323barrens
barres84427543barre_s
barrets94917103barrets
barters94223033barters
baryes116218503barye_s
berseems1263933berseems
beseems1175913beseems
biremes1138773biremes
boreens9310403boreens
breams104815043_breams
breeds94914883_breeds
breeks125310793_breeks
brees75632553_bree_s
carcels114516063carcels
carders104820353carders
careen84119493caree_n
career85822243caree_r
careless102813633careless
carers85133963car_ers
cares77369183car_e_s
caress85720263car_ess
carets85330773car_ets
caries85147623carie_s
carles85435083carle_s
carless95118493carless
carnets93918403carnets
carneys124310543carneys
caroms105619573car_oms
carpels115315463carpels
carpers114521253carpers
carpets113915333carpets
carrels95117303carrels
carroms11512403carroms
carses85233653carse_s
cartels94618123cartels
carters95327253carters
cartes86239473carte_s
carvels124914593carvels
carvers124817543carvers
carves115128453carve_s
chares115631803char_e_s
chargers144011323chargers
charges134615983charge_s
charisms15710263charisms
charleys1695633charleys
charmers154211333charmers
charms135218843char__ms
charnels13328173charnels
charters134115583charters
creams104715253_creams
creeds94714773_creeds
creeks124812923_creeks
creels84416943_creels
creeps104213623_creeps
cremes104517993_cremes
darers75921873dar_ers
dares66146703dar_e_s
darkens12409873darkens
darkeys15356533darkeys
darnels83710433darnels
darners83815773darners
darters84017603darters
deems85421773__deems
dreams94513983_dreams
drees65628523_dree_s
earless74316073earless
earners74016453earners
esteems935243esteems
fakeers14446673fakeers
farcers124713443farcers
farces115223323farce_s
fardels11389893fardels
farers95924053far_ers
fares85852873far_e_s
farfels13348213farfels
farles96025783farle_s
farmers124315263farmers
farms106324953far__ms
farness102912203farness
freers94717303_freers
frees86131393_free_s
gardens93312093gardens
gargets94614573gargets
garners83815983garners
garnets84115403garnets
garrets84413623garrets
garters84218233garters
garveys14124463garveys
greeds84314283_greeds
greens75716873_greens
grees65132473_gree_s
greets75117423_greets
haceks15447863ha_ceks
hackees165014103hackees
hackers164619043hackers
hades96035113ha_de_s
hadjees18356383hadjees
hadjes175210403hadje_s
haem95730983ha__em_
haeredes1246333haeredes
haes77651023ha__e_s
haets86525123ha__ets
haffets1636053haffets
hafters134614333hafters
hailers104017263hailers
hairless1157413hairless
hairnets1195633hairnets
hajes155420943ha_je_s
hajjes15485243hajje_s
hakes126034303ha_ke_s
hakims1537303ha_kims
haleness11312623haleness
halers94926913ha_lers
hales85449843ha_le_s
hallels103310133hallels
halms105225213ha__lms
haloes94623863haloe_s
halters104619803halters
halvers133311423halvers
halves124717093halve_s
hames106138703ha_me_s
hamlets123211403hamlets
hammams13386443hammams
hammers144216063hammers
hampers143616953hampers
hams96446133ha___ms
hances115621283hance_s
handers114224333handers
hangers113120813hangers
hankers144218133hankers
hansels104011653hansels
hanses95022633hanse_s
hansoms12238523hansoms
haoles94919803haole_s
hapless123311333hapless
happens14359173happens
haptens124511343haptens
harass9313943har_ass
harbors12412413harbors
hardass1139753hardass
harden105718533harde_n
hardeners1338083hardeners
harder105022403harde_r
hardest113118413hardest
hardies114923233hardies
hardness122411083hardness
hards96435653har__ds
hare76255733har_e__
harebell1344353harebell
harebells1444193harebells
hared95742183har_e_d
harelip1245953harelip
harelips1345213harelips
harked145422553harke_d
harken135116343harke_n
harkeners1636073harkeners
harks126333433har__ks
harlots103413293harlots
harls85634503har__ls
harm95637793har__m_
harmed125218833harme_d
harmer114719553harme_r
harmins123716723harmins
harmless1337403harmless
harped124418403harpe_d
harper115018403harpe_r
harpies123818313harpies
harpins123615703harpins
harps105926873har__ps
harriers113712433harriers
harries103525493harries
harrows132611033harrows
harshens1437603harshens
harslets1137833harslets
hartals10313023hartals
harts88441593har__ts
harvest132112753harvest
harvests14246173harvests
hashes125024803hashe_s
haslets102510863haslets
hassels104311013hassels
hastens106214813hastens
hastes95727073haste_s
haters94930403ha_ters
hates86742573ha_te_s
hatless103813443hatless
hatreds11307813hatreds
hatters104221523hatters
haulers104012443haulers
haulms11558503ha_ulms
hausens1077633hausens
havens124514043ha_vens
haverels14325753haverels
havers124721483ha_vers
haves116034873ha_ve_s
hawkers174210333hawkers
hawkeys20414703hawkeys
hawsers13409483hawsers
hawses125113993hawse_s
hayers124415943ha_yers
hayseeds1543283hayseeds
hazels185710083ha_zels
hazers184615953ha_zers
hazes174928323ha_ze_s
hearers104319783hear_ers
hearkens15336693hearkens
hearses104414533hearse_s
heartens113010153heartens
heeds95420423h__eeds
heels85625533h__eels
helms105619463h__elms
hemes105031083h__emes
hems95534943h___ems
herders113914123herders
heredes11313133heredes
heres86245903her_e_s
herms105626433h__erms
heroes94923823heroe_s
herpes115517323herpe_s
hiree85427803hiree__
hirers94518063hir_ers
hires86134343hir_e_s
hirsels10128343hirsels
hoarders12307433hoarders
hoarsens11306023hoarsens
hordes104921633horde_s
hornets104113553hornets
horses94729343horse_s
hurlers103714323hurlers
hurleys13407333hurleys
hurters103413643hurters
jarveys20123413jarveys
jereeds15326393jereeds
kreeps12427413_kreeps
larders83516943larders
laree56036293laree__
lares54852633lar_e_s
larges74824233large_s
largess8408913largess
larkers113014513larkers
larums83610533lar_ums
lateens74210553lateens
laveers10329363laveers
maihems1444303maihems
marcels113212373marcels
maremma1044463maremma
maremme1054603maremme
mares76457633mar_e_s
marges94525713marge_s
markers133516103markers
markets133314033markets
marrams11310123marrams
marrers93414313marrers
marses84827113marse_s
martens93714953martens
marvels123810093marvels
mayhems1763413mayhems
meseems1165603meseems
moreens939963moreens
nares55544153nar_e_s
neems77316293__neems
oarless73913373oarless
parcels113712663parcels
parents93418123parents
pareos87023773par_eos
parers85530743par_ers
pares77164483par_e_s
pareses94718883pareses
paresis93315093paresis
pareus85420743par_eus
parges94529543parge_s
pargets105215193pargets
paries84742513parie_s
parkers133816873parkers
parles86334403parle_s
parleys125212373parleys
parrels94713493parrels
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
payees114812903payee_s
preens85020113_preens
prees75937173_pree_s
proems104711163_proems
purees84721683puree_s
racemes1139093racemes
ragees74618663ragee_s
rakees104516973rakee_s
ramees84620893ramee_s
ranees64623963ranee_s
rareness81112853rareness
rares55247443rar_e_s
razees154314763razee_s
reams75729623__reams
redeems1037163redeems
reeds65430903__reeds
reefs85121663__reefs
reeks94124033__reeks
reels55333263__reels
rees45364193__ree_s
rehems113410983__rehems
rems66237723__r_ems
retems83914573__retems
sachems14348903sachems
saree55044663saree__
sarges75128593sarge_s
sarsens7311393sarsens
sateens73710753sateens
screams114810623screams
screeds106210293screeds
screens95212183screens
screes85023973scree_s
seems75525023__seems
shagreens1342633shagreens
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharpens13377813sharpens
sharpers133810943sharpers
shereefs1433863shereefs
sirees64624583siree_s
sprees85620643spree_s
streams94713373streams
streeks11378713streeks
streels73811343streels
streets73312613streets
tandems1037633tandems
tares57456563tar_e_s
targes74524593targe_s
targets84314223targets
tarres64723043tarre_s
tarweeds1244273tarweeds
taxemes1635853taxemes
teems76019783__teems
tharms115712243thar__ms
threeps12687043threeps
threes97117323three_s
treens65317873_treens
trees55835763_tree_s
tureens7289873tureens
unreels7258313unreels
vakeels14113733vakeels
variers103712663variers
varies94330873varie_s
varlets10411573varlets
varooms1248883varooms
varves124414783varve_s
wardens113711903wardens
warders113416813warders
wares88250583war_e_s
warless104015103warless
warmers124514293warmers
warms107726853war__ms
warners103315563warners
warpers123413583warpers
warrens103810893warrens
wharves16457133wharve_s
yarders113211593yarders
yarners104312203yarners
zarebas1836303zarebas
zareeba1842423zareeba
zareebas1943103zareebas

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.406440125.6
2DLD Change Limit1340274256.23321502.8
3Display Results4254250.1403035.7
 (SQL Overall)1786914256.77926359.5
 
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.